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.
