Workday formula

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.

Paul Newcome

So basically

[GPG SLA]@row + SLA@row

?

Then added to the Submitted Date?

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

Paul Newcome

Happy to help. 👍️

Paul Newcome

Are you able to provide some screenshots for context?

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).

Paul Newcome

So basically

[GPG SLA]@row + SLA@row

?

Then added to the Submitted Date?

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

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.

Paul Newcome

Happy to help. 👍️