Rollup percentage in project schedule template is not calculating correctly

Michele Deo · 10/31/18

I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to manually do parent/child formulas? If so, I would of though that the project smartsheet template would of handled that.

Please note that if I start a project with or without the Project information (first 6 rows of the project detail) the % complete doesn't change.

Paul Newcome · 10/31/18

I would suggest checking which columns are being used in your dependency settings first.

Paul.Koetke · 11/01/18

Hi Michele,

Great question! When using the % Completed column in the Project Settings, it calculates a weighted average. Since so many of your tasks do not have dates or a duration their weighting is zero. If you add expected dates, you'll see the % Complete update accordingly.

Let me know if this answers your question.

Paul Koetke

Upwork - Smartsheet Consultant

Rollup percentage in project schedule template is not calculating correctly

Comments

Categories