#DIV0 Error when using Children calc

Hi, I'm using the following calc to get the child average % displayed in the Parent row

=ROUND(AVGW(CHILDREN([% Complete]@row), CHILDREN(Duration@row)), 2)

This is working perfectly except for a #Div0 due to blank cells.

The duration is calculated from the difference between the Start Date and End Date

I know to use the IFERROR calc, but I'm struggling to work out how to wrap it in the above formula, any help would be appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!