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
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives