Divide By Zero Error(again)
Hello,
I am getting a #DIVIDEBY ZERO error when using the following formula:
=ROUND(AVG({CDuration}, {CDuration}))
What's confusing is that I am using the exact formula in another sheet and the formula is working as expected. I have went over the source(reference) sheet multiple times looking possible flaws or issues in the source data to no avail. Nothing on the new source(reference) sheet looks any different from the source(reference) sheet where the formula is working without issue. Any thoughts?
Thank you,
Best Answer

Hi @LeAndre P
Two things to check here. First of all, you only need to list the column to Average inside an AVG function once, like so:
=ROUND(AVG({CDuration}))
See: https://help.smartsheet.com/function/avg
Then if this is still giving you an error, the second thing to check is if any of the cells in your {CDuration} column have the "Divide by Zero" error. Formula errors can work like dominoes, so if one cell in that column has an error, it will surface in this other formula as well.
Do you have a formula in {CDuration}? If so, you can wrap an IFERROR Function around that formula to make sure it outputs a blank cell instead of an error.
Let me know if this helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

Hi @LeAndre P
Two things to check here. First of all, you only need to list the column to Average inside an AVG function once, like so:
=ROUND(AVG({CDuration}))
See: https://help.smartsheet.com/function/avg
Then if this is still giving you an error, the second thing to check is if any of the cells in your {CDuration} column have the "Divide by Zero" error. Formula errors can work like dominoes, so if one cell in that column has an error, it will surface in this other formula as well.
Do you have a formula in {CDuration}? If so, you can wrap an IFERROR Function around that formula to make sure it outputs a blank cell instead of an error.
Let me know if this helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Thanks for helping. Its working now.
Thank you!! :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!