# % 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%?

• ✭✭✭✭✭✭

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!

BRgds,

-Ray

• ✭✭✭✭✭

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!