Removing "#division by zero" from dashboard

Box2105
Box2105 ✭✭✭✭
in Smartsheet Basics

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?

· Share on FacebookShare on Twitter

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    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.

    · Share on FacebookShare on Twitter

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    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.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video