Skip to main content

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

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

Amazing - I’ll try it now 🙂

Reply


Terms & Conditions