Count all of the Level 1 Parent rows in a SmartSheet
In the document's Summary Sheet, I want to count all of the Level 1 parent tasks in the Sheet itself. In the example above, the answer is 2.
Best Answer
-
Hi Paul,
You can add a new column called "Counter" in which you are going to calculate the number of childrens that are included in each row. If the result is higher than 0, then the row is a parent.
=COUNT(CHILDREN([Dept Initiative Name]@row))
Afterwards, add an extra row at the top of your sheet to count the number of cells containing a result higher than 0.
=COUNTIFS(Counter:Counter, >0)
Hope this helps! Have a good day,
Mathieu | info@evolytion.com
Mathieu | Workflow Consultant
info@evolytion.com
Answers
-
Hi Paul,
You can add a new column called "Counter" in which you are going to calculate the number of childrens that are included in each row. If the result is higher than 0, then the row is a parent.
=COUNT(CHILDREN([Dept Initiative Name]@row))
Afterwards, add an extra row at the top of your sheet to count the number of cells containing a result higher than 0.
=COUNTIFS(Counter:Counter, >0)
Hope this helps! Have a good day,
Mathieu | info@evolytion.com
Mathieu | Workflow Consultant
info@evolytion.com
-
That is AWESOME!
Much more elegant than a formatting a rule I was going to apply to the Task Name if I didn't get a better answer.
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!