I don't know if this is possible at all. So I have a column and it's the importance of the tasks in the sheet. I have another sheet that has a summary and tally up how many tasks are there for each severity level. Someone did this manually. First, I want to ask if there is a way to produce a column of the severity column but without the duplicates with the numbers of each items, so we don't have to manually do it. And if this is possible can I have the summary sheet automatically update when a new severity level is added? Like for example, now I have 50 tasks, 30 is minor, 15 is major, and 5 is urgent. If I added a new task that has the severity of critical, can I have the summary sheet automatically add a row and count how many critical tasks there are?
eg.
Before:
Severity number
Urgent 5
Major 15
Minor 30
Total 50
After adding a new task in the tasks sheet:
Severity number
Urgent 5
Critical 1
Major 15
Minor 30
Total 51
