cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Partisan
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
BakerAlex
Resolver I
Resolver I

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 @BakerAlex ,

 

I am getting this error: 

The formula contains a syntax error or is not supported.

 

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 @BakerAlex - still getting invalid syntax

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.

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,148)