Hi,
I'm trying to create a formula to determine if an action is overdue. If RAR is open and it does not have an action created or it does have an action created and the due date is before today then "overdue", otherwise "in process".
I have tried this but it is not being recognised as a formula. I've not yet attempeted to include the "in process" part
IF(O2="OPEN"&(T2="NO"),IF(T2="YES"&U2<TODAY),"OVERDUE")
O is RAR Status
T is Action created
U is Due date
Can someone point out where I'm going wrong?
Thanks
Bookmarks