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
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
π΄ GOLD 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
Check out the Formula Handbook template!