Smartsheet's Error in % Complete Rollup

edited 12/09/19 in Formulas and Functions


I recently realized that Smartsheet has a major flaw in rolling up % Completion.

In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct % complete is 10%: Completed work (1 day) divided by total work (10 days) equals 10%. 

In other words, task1 is overweighed and all subtasks under task 2 are underweighted. 


Figure 1

I have escalated this to smartsheets and would like to share with the community as this could have serious impact if you are managing a complex project. 





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!