#Divide by Zero on AVG(CHILDREN) formula


Hoping someone can help here!

I have rows that are parent, child and grandchild.

The formula in the child row to give a percentage of grandchild that are complete is as follows: =ROUND(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) * 100) + "%"

I'd like the parent row to show the average of all the children but when I do =AVG(CHILDREN() I get a Divide by Zero error even though there are children and all have a percentage.

Can anyone help me figure this out? Included screenshot.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!