Counting all children, including nested children
Hi - I think I have stared at this enough and tried many ways of sum and count formulas, but is there an easier way to count ALL the children of the highest outdented parent row which has multiple "sub-rows" with children underneath? I am trying to count the cells that are nexted beneath those rows and the children () function will only return count 1 level below the parent not 2 or 3 for example.
Answers
-
Yay, I know this one. You need =COUNT(DESCENDANTS()).
I put an example on this sheet: https://app.smartsheet.com/b/publish?EQBCT=73507c09f5b24232aba53df48a13aefe
Another handy one is =COUNT(ANCESTORS())
Not for your use case, but I use it all the time to apply formulas and conditional formatting based on where a row lands in a hierarchy.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!