What is WORKDAY formula with SLA built in

Nancy Pet
Nancy Pet ✭✭
edited 11/01/22 in Formulas and Functions

Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays).

Thank you so much



  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Nancy Pet ,

    First of all you'd need a column with holiday dates set up (this can be in another sheet).

    If I've understood your pictures correctly in that you'd like the Copy to Editor to be 2 workdays after Wireframe Approved, the formula would be one of the below:

    If your holiday dates are hidden on the same sheet in a column called Holidays:

    = WORKDAY([Wireframe Approved]@row, 2, [Holidays]:[Holidays])

    If your holidays are listed on another sheet, substitute the last part to a cross sheet reference. This is probably better as allows you to simply drag the formula across if you want the same +2 days in other adjacent cells.

    Hope this makes sense and helps!

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 11/02/22

    Hi @Nancy Pet

    I would recommend this formula.

    =WORKDAY([Date]@row, 2)

    Where "[Date]@row" will be replaced with your column name and row reference that you're trying to add workdays to.

    Where 2 is the number of Workdays you're trying to add.

    Hope this helps!



  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    @Nick Korna,

    I didn't see your answer when I submitted one. I must have still been testing my suggestion and writing my post when you submitted yours. Sorry for the duplication.

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    @Ray Lindstrom - no problem, it's all good. :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!