is there a formula that sum only for direct children
Mo
✭
if I have a project and this project has task and the task have sub task
the hierocracy will be the project is the parent, the task will be children for the project, the sub task will be children for task
I want a formula that I apply in the project row that is going to sum the utilization percentage from tasks only "direct children" and the same for task, it should only look for the sub task utilization underneath it
Answers
-
=SUM(CHILDREN())
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives