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