Workday formula

Dustin.Bissette

Dustin.Bissette ✭

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

I want to insert the WORKDAY function into my formula. Where would be the correct location?

=IF(ISBLANK([Acutal Start]@row), ([New Estimated End]3 + [\[Duration\]]@row), ([Acutal Start]@row + [\[Duration\]]@row))

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

06/21/19

=IF(ISBLANK([Acutal Start]@row), WORKDAY([New Estimated End]3 + [\[Duration\]]@row), WORKDAY([Acutal Start]@row + [\[Duration\]]@row))

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
Workflow to transfer Parent row and not Child rows
I have a workflow to transfer data from one sheet to another however I only need the parent row to transfer and not the child rows. How would I do this?
Cannot type a Name in Contact field of My Smartsheet Contacts
My Smartsheet Contacts, Add, Contact field opens. I go to type Name. Name starts with the letter "J" The letter J does not type into the field. I tried a Bluetooth keyboard and Laptop keyboard, so it is not a keyboard error. This seems like a bug. Any idea how to resolve this? Thank you.

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