Query data from another table

[Dom_Moir]

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

[Jeremy_Oglesby]

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]

Amazing - I’ll try it now :slightly_smiling_face: