Hide Divide by Zero Error
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


Hello,
Happy to help! Paul is correct adjusting the parenthesis would work, don't forget to remove the bracket. Also, the Children Function will reference all child rows within the same column, you may not need the [Column]@row part of the formula.
This is further outlined here: https://help.smartsheet.com/function/children
The formula could look like this:
=IFERROR(AVG(CHILDREN([Column]@row),""))
or
=IFERROR(AVG(CHILDREN(),""))
Cheers,
EricSmartsheet Support

Thanks so much!

Thank you.


I have a similar question, though I have a typical If function. The Iferror doesn't seem to replace it to fix. The formula currently for Fee Spend Percentage is:
=[Spent (Ajera)]@row / [Contract Amount]@row
applied to column. The formula currently for Under Fee is:
=IF([Project Complete (Percentage)]@row > [Fee Spent (Percentage)]@row, "Yes", "No")
applied to column. I would prefer that if I schedule a project but the contract/fee information is not input, it would not identify anything at all instead of #DIVIDE BY ZERO.
As an aside, would anyone have any idea of how to grab Ajera data instead of needing to input it manually?
I appreciate any help!

Hi @Tehren
When you say that the IFERROR function doesn't help, what happens? Are you seeing the same error?
The IFERROR function for your formula would be structured as follows:
=IFERROR([Spent (Ajera)]@row / [Contract Amount]@row, 0)
Did that work?
Cheers,
Genevieve
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!