Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
#DIVIDE BY ZERO” error
I have a formula in Smartsheet that calculates Accuracy by using the following formula: Estimated amount-actual amount/actual amount. Until the “actual amount” is filled in (sometimes weeks or months later) the formula returns a “#DIVIDE BY ZERO” error. The error is fine as far as the calculations go on my pivot tables. However, when that column comes over from Smartsheet into Excel, it transfers as TEXT and therefore impacts my pivot tables for my Accuracy metrics. I have to manually input the formula in Excel before I update my pivot tables so I can update the metrics. Is there a fix for this?
Any guidance offered is greatly appreciated.
Comments
-
You could add if(actual amount > 0) before your formula to prevent dividing by zero...
Hope that helps!
Étienne
