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)
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.