Countif based on array of values
I hope this is possible!🤣
I have this list of states where a "Task Name" can have multiple sub-states listed on "Column 1"
I've already "merged" the sub-states. Example below with Blocker --> "Test Blocked" & "Blocked"
=JOIN(COLLECT([Column 1]82:[Column 1]89, [Task Name]82:[Task Name]89, [Column 4]86), " ")
and now what I would like to reach is a countif on my database of values, that would be count the number of Stories that either have "Test Blocked" or "Blocked" as I'm selecting the parent "Blocked"
I case I would have "To Do" I would search for all sub-states under To Do, that would be "To Do", "new", "Pending Sign off" or "Reopened"
So far I've been working with Or(contains()), where I have a contains for each type, but every time a sub-state changes I need to re-arrange all my formulas manually, so I'm seeking for a more automated way.
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!