Oct 15, 2018 11:08 PM
Hi,
I need a formula to calculate 4 seperate Service level agreements
The SLAs are as follows:
4 hours
Same Day
48 hours
10 days
I need a field to show the “due” date for each record based on its sla.
My base creates Opened Date when record is created.
I assume I need a nested formula to calculate the date/time when the SLAs will expire.
Ive written this but only the first part works
IF({SLA}=“same day”, DATEADD({Opened Date}, 1, ‘DAYS’), DATEADD({Opened Date}, 60, ‘DAYS’))
IF(SLA=“A 4 Hour”,(DATEADD({Opened Date}, 4, ‘hours’,IF(SLA=“P 10 Days”,(DATEADD({Opened Date}, 10, ‘days’))))))
Once the completion date is added I will create a formula to comfirm if the SLA is met or not.
Many Thanks,
Ant
Oct 16, 2018 12:18 AM
Some ideas:
SWITCH()
instead of a nested IF.Oct 21, 2018 10:02 AM
Hello,
Thank you for the reply.
I have written the IF statement in full which works as below - HOWEVER this is without the DATE ADD.
How do I add this in for each one?
IF(SLA=“A 4 Hour”, “4”, IF(SLA=“P 10 Days”, “10”, IF(SLA=“Same Day”, “Same”, IF(SLA=“D 48 Hours”, “48”))))
Many Thanks,
A
Oct 21, 2018 01:54 PM
Hi,
Just to update I worked this through, Just missing how to calculate a time up to Midnight for the same day time?
IF(
SLA=“4 Hour”,
DATEADD({Opened Date}, ‘4’, ‘Hours’),
IF(SLA=“10 Days”,
DATEADD({Opened Date}, ‘10’, ‘Days’),
IF(SLA=“48 Hours”,
DATEADD({Opened Date}, ‘2’, ‘Days’),
IF(SLA=“Same Day”,
DATEADD({Opened Date}, ‘0’, ‘Days’)))))
Ant