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

Record a date when a status changes from closed to open
I have a tracker where I am tracking dates when tasks are closed, but I'm running into an issue where some items are being "reopened" for additional follow-up. What I want to do is know WHEN that happens (so I can track trends or culprits LOL). Is there a way to record a date when this happens? My record a date workflow is…
Is there a way to put a display name on a hyperlink in the Form Description?
Is this possible? I see it was asked quite a few years back and a couple people added it as an enhancement, just wanted to see if it was ever implemented?
Adding a editor
Hello, I have bough PRO licence. It shows that up to 10 editors are included. But when I try to add the editors, it shows me, that there are 0 licences available. What does that mean? Are there editors included or do I already need to buy more licences? Right now only 1 user can see the sheets.

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