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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

Unable to Create a Project as a Child Under the Parent Blueprint
I am trying to create a project as a child under the parent blueprint to maintain a hierarchical structure within the workspace. However, instead of being created under the parent folder, the projects are being provisioned as separate folders at the same level.
Project Provisioning Failure – Error Copying Template Source Folder
When attempting to provision a project, the provisioning process fails with the following error: {"done":false,"logs":"Error when attempting to copy template source folder."} Show more lines As part of troubleshooting, the AI Agent recommendation to review the blueprint source folders for broken dashboards and reports was…
Automation not triggering
Good afternoon. I am trying to create an update request to have contacts in a cell complete a voting task. I have been asking the AI what the issue is and it had good suggestions, everything it suggests is occurring on the sheet. The update request is to trigger when the "Launch update request" changes to checked. It will…