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!

#DIVED BY ZERO

Nemo

I am trying to get this to just show a zero when it occurs. This is the formula I am trying to use, can anyone assist?

=SUM([2019 DART]3 * 200000 / [2019 Hours]3)=IFERROR [2019 DART Rate],"0")

Find more posts tagged with

Comments

Mike Wilday

Try wrapping your formula with the IFerror.

=IFERROR(SUM([2019 DART]3 * 200000 / [2019 Hours]3), 0)

Mike Wilday

Here is an article specifically on how IFERROR is to be used: https://help.smartsheet.com/function/iferror

Nemo

Thank you! That fixed me.

Mike Wilday

Awesome. Glad it worked for you. Have a great day.

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
I cannot access my Paid account
I upgraded from the free trial to a paid account. When I log in I am set to the trial account and cannot get to my paid account. HELP
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account