% Complete is Not Working

edited 12/09/19 in Formulas and Functions


I have a spreadsheet with about 85 tasks and subtasks, the % Complete isn't working. It's show the percent completed as 99%, when only about 10 tasks have been completed for this project. I tried to disable the Dependency Settings and use the =AVG(CHILDREN()) formula but then I got the divide by 0 error. So then I tried =IFERROR(AVG(CHILDREN())) and still received an error.

What is the secret to get the % Complete to calculate all the tasks even if it has not started and the % Complete is 0 or blank?

Thank you,



Smartsheet Percent Column.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!