Hide Divide by Zero Error

Katye Reed
Katye Reed ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. 

Could someone please help? I tried the following 


Thanks so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!