Counting # of rows under a parent row that meets a certain criteria
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!!
Answers
-
See below:
=COUNTIFS(CHILDREN(Step@row), @cell <> "", CHILDREN(Status@row), @cell = "In progress")
-
Thank you for this. Unfortunately, it is only counting the two cells being referenced and not all the cells in the children row that meets the criteria. I don't understand the syntax of this formula, so I am not entirely sure where the problem may lie. Can you explain why you have used each piece of this formula so I may be able to adapt it to what I need?
-
Where did you put the formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!