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")
Try wrapping your formula with the IFerror.
=IFERROR(SUM([2019 DART]3 * 200000 / [2019 Hours]3), 0)
Here is an article specifically on how IFERROR is to be used: https://help.smartsheet.com/function/iferror
Thank you! That fixed me.
Awesome. Glad it worked for you. Have a great day.
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
