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
- 64K Get Help
- 412 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 140 Just for fun
- 57 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives