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)))))
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.
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
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
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |