IFERROR

Tribeiro

Tribeiro ✭✭✭

05/28/19 edited 12/09/19 in Smartsheet Basics

how can I add IFERROR to this formula

=WORKDAY([Start Date]140, 15)

I tried =IFERROR(WORKDAY([Start Date]140, 15, ""))

and it didnt work

Tags:

IT & Operations

0 ·

Comments

Nic Larsen ✭✭✭✭✭✭

05/28/19

Try:

=IFERROR(WORKDAY([Start Date]@row, 15), "")

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Updating dates to build a project plan
I am a complete newbie so please bare with me. I am creating a project plan with a target submission date. We have a guideline how much time should each task take. Is there a way that dates populate automatically when you are planning backwards? I cannot believe I need to calculate each ask and enter start and and date…
Interactive Dashboard without Dynamic View?
Hi, I have a sheet where the user enters a code which then brings back metadata from other sheets. I would like to have this field on a dashboard so the end user doesn't have to navigate to the sheet but enters it in the dashboard (which is the field in the sheet itself). I have searched and I think this is possible with…
Logic performance and default values with 3 drop options
On my form- Field question "Attention Needed" has 3 options, "OK", "NEEDS ATTN", or "Out of service". I have twelve subsequent fields that have options either "OK" or "NEEDS ATTN". I am having a problem with the logic and performance of those answers, perhaps I have the structure set up wrong. If field question "attention…

Help shape the future of Smartsheet.
Share your ideas and feature requests.