Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Removing "#division by zero" from dashboard
Box2105
✭✭✭✭
I have a financial report in my dashboard that show the forecast, actuals, variance and variance % for each month (Jan to Dec). Mid-year months that done not have actuals yet show "#division by zero" in the %VAR column.
Is there a way to not show the "#division by zero" in the dashboard?
Best Answer
-
Add "IFERROR" function to the start of your existing formula and end it with a double quote ("") so that it will leave the cell blank instead of displaying an error.
Answers
-
Add "IFERROR" function to the start of your existing formula and end it with a double quote ("") so that it will leave the cell blank instead of displaying an error.
