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 create...
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”,
DA...
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(SL...
