cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Prodigy
Post Prodigy

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
Anonymous
Not applicable

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 

Hi @Anonymous ,

 

I am getting this error: 

The formula contains a syntax error or is not supported.

 

Anonymous
Not applicable

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 

Hi @Anonymous - still getting invalid syntax

Anonymous
Not applicable

Hi,

 

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

 

Thanks,

Alex

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
Not applicable

Hi,

 

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

Created + 8/24

 

Hope this helps,

Alex

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,476)