Summing allocation of each child for a Parent
We have a project capacity sheet for my team. We have it set up as each person as the parent with their projects as the child rows. I want to sum their total allocation of each child in the parent row. Also rows are often added and removed, is there way to manage that so that there isn't any formula updating. Image attached to better understand what I am looking to solve.
Answers
-
@KathrynEK yiu can calculate try the formula with DESCENDANTS(): Returns all descendants of the current row (including child rows and deeper levels). if you can not succeed tell me .
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
Thanks. I think I was overcomplicating it. I was able to figure out what I needed
=SUMIFS([Allocation %]:[Allocation %], [Assigned Resource]:[Assigned Resource], [Team Member]@row)
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!