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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!