Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Gosh darn it - another IF query :/

Topic Labels: Formulas
1657 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Amazing - I’ll try it now :slightly_smiling_face: