The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

Accessing Children of Children if it meets certain Conditions

Hi,

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!!!

RequirementTallying.png


Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!