Is there a way to count the number of CHILDREN in a column?
Hello,
I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and then "Project Name" (CHILD). I want to count the total number of CHILDREN in that column, but exclude the PARENT rows in order to COUNT the number of CHILDREN, and hence, the total number of projects. Can this be done?
Thanks,
Jay
Best Answer
-
=COUNT(CHILDREN([Primary Column]:[Primary Column]))
This will count the # of child rows in the Primary Column (if you didn't rename it) with multiple groups of parent/child rows.
Answers
-
Here is a view of what I am asking above. You can see that I have Cells labeled "PM 1, PM 2", etc. Beneath each are CHILDREN rows (I have expanded the bottom one as an example). I am trying to count the total number of those children rows so I can display the total number of projects we have ongoing.
Any help is appreciated!
-
=COUNT(CHILDREN(Parent_Task_Name))
-
=COUNT(CHILDREN([Primary Column]:[Primary Column]))
This will count the # of child rows in the Primary Column (if you didn't rename it) with multiple groups of parent/child rows.
-
Thanks guys - it worked and I am good to go!! Much much appreciated!!🙏
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!