Overall Average Percent Compete

Hi All,


I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows.

For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 0) * 100, 0) + "%"

For the completed?11 cell I tried to use the formula =AVG(CHILDREN()) and I get a #DIVIDE BY ZERO error. 

How do I get the Completed?11 cell to show me the total percentage for the entire project? Please note this sheet is for project  templates.

% Completed.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!