% Complete showing effort is late when it is on schedule

I have a set of tasks that are currently on-track, but the % Complete is calculating only at 9%. When I do a manual check I find that I am 30% into the effort and 26.25 complete.

Why is the % Complete showing only 9%?


  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    Hi @earl_bennett,

    If I'm understanding right, it's because the % Complete roll-up considers the Duration of each task.

    If you have 4 tasks; 3 have a duration of 1 day, and 1 has a duration of 100 days;

    Completing the 3 tasks with a 1 day duration will not cause a 75% complete for the parent row roll-up. This is because of the 103 days of duration, only 3 days were counted for.

    This is called a weighted roll-up.

    Hope this helps!



  • earl_bennett
    earl_bennett ✭✭✭✭✭

    I ended up just creating my own simple formula to calculate the Actual %Complete, and I'm using that column in the Gantt. Thank you! =IF(COUNT(CHILDREN()) = 0, [% Complete]@row, AVG(CHILDREN()))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!