Counting # of rows under a parent row that meets a certain criteria

Options

Hi!

I am trying to figure out what formula to use in the below situation:

My sheet has parent rows that determine various phases of a project. Each child row has a status (in progress, complete, etc.) for each step (step 1, step 2, etc.). I am trying to figure out what formula would count how many "in progress" child rows I have under one particular parent row (i.e.) How many steps are completed in phase one - see picture). Thank you!!


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!