Count Descendants
Jim Mika
✭✭✭
Hi,
Trying to figure out formula to count descendants if value is greater than zero. This calculation is all in one column. Not sure were I'm going wrong but this seems like it should be a simple one. Any help would be appreciated.
Answers
-
Does this do what you want:
=COUNT(DESCENDANTS([Primary Column]@row))
This counts the number of descendants of the current row. If a row has 0 descendants it returns 0.
If you prefer blank to 0 you can put this formula within an IF to only display the answer if the answer is greater than 0.
=IF(COUNT(DESCENDANTS([Primary Column]@row)) > 0, COUNT(DESCENDANTS([Primary Column]@row)))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 205 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives