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.
Hi, in a form under a sheet I have one field with a multiple choice dropdown, and each of the option is linked with Logic with another field (also a multiple choice dropdown if it matters). If I choose only one of the options in the field 1, the correct new field appears, but in case of multiple choices, I get either only…
I created my Smartsheet account yesterday using my Google email (patrick@diamondsolarllc.com). My company is based in the United States, but my account appears to have been created in the EU region (smartsheet.eu). I don’t mind being on the EU region as long as it does not cause issues, but I am currently experiencing the…
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
