Formula(s) for reporting Counts of Children w/ Status
I have a basic plan. Let's say I have 5 Parents, each with a handful of children.
I know there are many ways to get a report of the data I'm looking for, but I want formulas. I'm looking to get the correct syntax for formulas that would give me counts of the children under the parent, by status.
So:
For Cell A - give me the count of children under parent 1 that are in progress
For Cell B - give me the count of children under parent 1 that are complete
For Cell C - give me the count of children under parent 2 that are in progress
and so on......
Thanks in advance for the feedback!
Answers
-
You would need a column that pulls the identifying parent level info onto each of the child rows.
=PARENT([Task Name]@row)
From there you can use your standard COUNTIFS to count the statuses as well as the new helper column being equal to the specific text.
-
Thank you Paul, working like a charm.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!