Workday formula

Rocky
Rocky ✭✭✭

I have a workday formula in place now which calculates an expected due date from the date of submission. I've checked the results and find that the calculations are off by 10 days.

The expected date should be a combination of two SLAs.

The first calculating the due date from the submitted date using a department SLA of 2

The second calculating from the Stakeholder Turnover date using a department B SLA of either 20 or 10

The original formula reads as follows:

=WORKDAY(submitted@row,SLA@row)

The second I wanted to use is below and I get unparseable.

=WORKDAY([Submitted@row], GPGSLA@row,[DepartmentB@row],SLA@row))

The GPG SLA is 2 and Department B SLA is either 20 or 10

Any ideas to make this work? Appreciate any insight you can give me.

Thank you very much,

YCRock

Best Answers

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide some screenshots for context?

  • Rocky
    Rocky ✭✭✭

    The submitted date is when the request was first received. The expected due date was calculated as 1/23/23

    The column SLA is based on a secondary stakeholder's approval schedule. There are two options 20, 10.

    The Column GPG SLA was added. They need two days to review before passing to the secondary approver. When their review is complete, they mark approved and the Stakeholder Date is populated by automation's "Record a date." function.

    Expected due date should be a combination of the GPGSLA and the Stakeholder Date start (if you will).

    Thank you very much,

    YCRock

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer βœ“

    So basically

    [GPG SLA]@row + SLA@row

    ?

    Then added to the Submitted Date?

    =WORKDAY(Submitted@row, [GPG SLA]@row + SLA@row)

  • Rocky
    Rocky ✭✭✭

    I tried that and received unparseable. Maybe I missed the comma. Thanks a bunch! I'll try it now. It worked! Thank you again! I didn't have the comma in the right place.

    Thank you very much,

    YCRock

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer βœ“

    Happy to help. πŸ‘οΈ

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!