If Blank, leave blank otherwise Networkdays fomula

AHowell

AHowell ✭

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

Is there a way to create a formula that only runs if there is a date in a specific coloumn? We are trying to see turnaround times but do not want to see #invalid if the document has not been exected yet.

0 ·

Comments

Andrée Starå ✭✭✭✭✭✭

06/05/19

Hi,

Yes, you can add an IFERROR function to the formula.

More info: https://help.smartsheet.com/function/iferror

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

06/10/19

Hi,

How did it go? Did you get it working or do you still need help?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

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