Rollup percentage in project schedule template is not calculating correctly

Michele Deo

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

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

Paul.Koetke

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