SPO Calculated column to work out SLA based on days and hours

[sudosaurus]

Hello,

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?!

I have SLA priorities on my list as per the below:

5= 365 days

4= 5 days

3= 5 days

2= 1 day

1= 8 hours

=IF(Priority="5",Created+365,IF(Priority="4",Created+5,IF(Priority="3",Created+5,IF(Priority="2",Created+1,IF(Priority="1",Created+0.8)))))

[sudosaurus]

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?!

I have SLA priorities on my list as per the below:

5= 365 days

4= 5 days

3= 5 days

2= 1 day

1= 8 hours

=IF(Priority="5",Created+365,IF(Priority="4",Created+5,IF(Priority="3",Created+5,IF(Priority="2",Created+1,IF(Priority="1",Created+0.8)))))

[Anonymous]

Hi,

You could use addDays() and addHours():

=IF(Priority="5", addDays(Created, 365), IF(Priority="4", addDays(Created, 5), IF(Priority="3", addDays(Created, 5), IF(Priority="2", addDays(Created,1),IF(Priority="1", addHours(Created,8))))))

Hope this helps,

Alex 

[sudosaurus]

Hi @Anonymous ,

I am getting this error: 

The formula contains a syntax error or is not supported.

[Anonymous]

Hi,

Sorry wrong formula:

=IF(Priority="5", DateAdd(Created, 365, Days), IF(Priority="4", DateAdd(Created, 5, Days), IF(Priority="3", DateAdd(Created, 5, Days), IF(Priority="2", DateAdd(Created,1, Days),IF(Priority="1", DateAdd(Created,8, Hours))))))

Hope this helps,

Alex 

[sudosaurus]

Hi @Anonymous - still getting invalid syntax

[Anonymous]

Hi,

Would you be able to share a screenshot of the flow?

Thanks,

Alex

[sudosaurus]

Ah, maybe this is where I'm going wrong? 

I wanted to do this directly within a calculated column in SharePoint? This is where it is failing.

[Anonymous]

Hi,

Ah. if it is only the hour calculation which is causing the issue, then try:

Created + 8/24

Hope this helps,

Alex