Sign in to join the conversation:
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)
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
I’m hoping to get a second set of eyes from the community in case I’m missing something obvious or there’s a cleaner pattern I should be using. I’ve used ChatGPT to try and help me group/organize my situation coherently…. Because at this point I feel crazy… I’ve literally worked on this for hours. Environment •Smartsheet…
