SLA Dateadd formula


#1

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


#2

Some ideas:


#3

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


#4

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