Rollup percentage in project schedule template is not calculating correctly

Michele Deo
edited 12/09/19 in Smartsheet Basics

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
    Paul Newcome ✭✭✭✭✭✭

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

  • Paul.Koetke
    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