# Dashboard and Sheets - Making 0 appear instead of error or formula

✭✭✭✭✭✭
edited 12/09/19

Good evening

When we are setting up dashbaords and we have not yet enetered data , how do we make that data show a "0" instead of "# Divide By Zero" , it just looks messy....

Thank you

Tags:

• Wrap your formula with an IFERROR() formula.  For instance...

=IFERROR(1 / 0, 0).  Since 1/0 will give you an error, the formula will return a 0.

• ✭✭✭✭✭✭

OK thanks so if my formula was

=SUM([Series ID]43 / [Series ID]42

then it would be

=IFERROR(SUM([Series ID]43 / [Series ID]42) ?

It stilll is not working,

Sorry still learning the syntax

• ✭✭✭✭✭✭
edited 03/05/19

Close. You just need to add what to display if there is an error.

=IFERROR([Series ID]43 / [Series ID]42, 0)

=IFERROR([original statement], [what to display if there is an error in the original statement])

• ✭✭✭✭✭✭

Thank you

I got the =IFERROR([Series ID]43 / [Series ID]42, 0)  to work! Awesome

But I tried with this one below and it is not returning a 0

=IFERROR([Performance Meter]85),0)

Newbie! Sorry but your help is greatly appreciated!

• ✭✭✭✭✭✭

You have an extra closed parenthesis after the cell reference. Removing that should get you squared away.

=IFERROR([Performance Meter]85, 0)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!