Help

Re: Gosh darn it - another IF query :/

1145 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to reference two fields in my IF but I just can’t seem to make it work…

IF({Due date}>TODAY(),"+",“OK”), IF(Status=“Complete”, “Complete”, “OK”))

2 Replies 2
IF(
   IS_BEFORE(TODAY(), {Due Date}),
   "+",
   IF(
      Status="Complete",
      "Complete",
      "OK"
   )
)

This first checks the {Due Date} against Today’s date, and if it is later than Today’s date, returns “+”.
If {Due Date} is not later than Today’s date, then it moves on the check if {Status} = “Complete”.
If so, it returns “Complete”.
If that check fails as well, then it returns “OK”.

Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

Amazing - I’ll try it now :slightly_smiling_face: