Weighted Percentage for Parent Rows

Robert Comrie

Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below;

 

1. (Project) Big Steel Project  - 100%

 

2. (Parant)Steel Box               -  50%

3.   (Child) Bottom      70%

4.   (Child) Sides         30%

 

5. (Parant)Steel Post               -  30%

6.   (Child)Short Posts 20%

7.   (Child)Long Posts  80%

 

8. (Parant)Steel Beams          -  20%

9.   (Child)Short Beams 50%

10.  (Child)Long Beams  50%

 

The problem I'm having is that the completed percentage is not reflective of actual workload to be completed.

 

Thanks for your help

Shaine Greenwood

Hello Robert—

 

If you're using dependencies in your sheet, percentage complete is automatically rolled up to parent rows as a weighted calculation, using the duration and % complete of the children to determine the % complete of the parent rows. The % complete must be manually set in the child rows to see the parent roll up.

 

You'll need to disable dependencies in the sheet and create your own formula to calculate what you need. Check out our Using Formulas article for more information: https://help.smartsheet.com/articles/775363-using-formulas

Robert Comrie

Thanks Shaine...I'm new to smartsheets and was not aware that the rolled up calculation was weight against the duration. Maybe the sheet I am working with does not have any one parent with a much longer duration for me to notice the weight difference. Thanks as well for the formula tip - it will definately help if I need to do more than what the standard features offers.

 

 

manuelws

I would like to second this request, with a twist. It would be great to be able to set up custom weighting and custom ranges of source/child rows/cells for percent complete rollups.



Quite often I have 10 tasks in a project but they are not equally weighted. I'd love to be able to define a range of rows to perform a custom percent rollup, and assign custom percentages to each row.