Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Hide Divide by Zero Error

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

Hello,

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 

=IFERROR(AVG(CHILDREN([Column]@row],"")))

Thanks so much!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions