Accessing Children of Children if it meets certain Conditions
I'm having trouble getting a formula to help me tally info for a dashboard. I have a sheet that is tracking the requirements of several capabilities of a system that we're migrating. The Column called Core Capabilities, has 4 children (Categories); Critical, High, Medium, Low. Each of those categories has a range of children (Requirements) that start at 0 and go on.
I'm trying to capture in a formula how many total Criticals, Highs, Mediums, and Lows I have. I'm also trying to capture the total status in each of these categories (Red, Yellow, Green which is tracked in a separate Status Column)
I mocked up an example of what my requirement tracking sheet looks like. There are many more Core Capabilities in the actual sheet. And the Status is actually an output of the action in several columns to the right. I appreciate any help!!!
Help Article Resources
Check out the Formula Handbook template!