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”))
Gosh darn it - another IF query :/
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”.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.