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
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
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])
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)
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…