nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

BESP10

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

Find more posts tagged with

Sheets

Publish

Mobile

Formulas

Reports

Comments

Dan Seidler

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.

BESP10

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

Paul Newcome

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])

BESP10

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!

Paul Newcome

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

=IFERROR([Performance Meter]85, 0)

Sign in to join the conversation!

Quick Links

Trending discussions

not getting confirmation mail from form smartsheet
hi team for not getting quick response copy form smartsheet what are the reasons
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
Checkboxes not showing after mobile update
Just wondering if anyone else experiencing this issue? The checkbox cells would normally be an empty checkbox but update the recent mobile app update, they would disappear on any column with checkbox type, specifically on sheets and reports, dynamic views is good. This is only happening on mobile app, browser works fine.