WORKDAY for today?

AlFresco
AlFresco ✭✭✭
edited 12/09/19 in Smartsheet Basics

Is there such a thing as a formula for WORKDAY for today?  I.e. modifier is 0 instead of + or -

I'd like a field that can go off another field or (work on itself) that can adjust itself to the closest workday, for example.

=WORKDAY([Due in PROD]1, 0)

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something along the lines of...

     

    =WORKDAY(IF(ISDATE([Due in PROD]1), [Due in PROD]1, TODAY()))

     

    Basically the IF portion will input whatever date is in the [Due in PROD] column. If there is no date, then it will input TODAY(). It will then run the WORKDAY function based off of that result.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com