cancel
Showing results for
Did you mean:  Post Partisan

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

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

7 REPLIES 7  Resolver I

Hi,

``=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  Post Partisan

Hi @BakerAlex ,

I am getting this error:

The formula contains a syntax error or is not supported.  Resolver I

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  Post Partisan

Hi @BakerAlex - still getting invalid syntax  Resolver I

Hi,

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

Thanks,

Alex  Post Partisan

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.  Resolver I

Hi,

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

Created + 8/24

Hope this helps,

Alex   