Sign in to join the conversation:
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.
I have my sheet set up and saved. Then, I created a report based on columns in the sheet. I added the following columns, saved the report. Data already in the sheet was showing in these columns. Now three times, I've opened the report, and these columns keep showing up as Columns Not Found. I unchecked the columns and…
I am trying to delete some old Workspaces that I created and am the owner of. However, it says I do not have sufficient permission to delete. I am sure it's a simple answer, but I don't know what it is. Thanks!
From Sheets folder it is no longer possible to create an asset directly from this location. The dropdown menu has been removed from Actions It is now required to right click on Sheets folder No visible dropdown menu for creating an asset. Now required to click on Create taking the end user to this screen. Options to create…
