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 information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!