Formula for when Deadline is overdue, excluding certain statuses

[Andy_Abelow]

I’ve looked all over for this, and there are formulas that get close, but nothing that quite gets what I want.

If the date is equal to or past the date under “Deadline”, autofill the formula cell with “OVERDUE”, unless the Status column (single select) is tagged “Complete”, in which case it should say “Done” no matter what (before, on, or after deadline)

Else-wise, the formula cell should be blank.

[Andy_Abelow]

Meaning, if status is Complete or Archived, fill cell with “Done”

[Andy_Abelow]

Sorry I worded it wrong - i just meant, how to formula for showing “Done” if several statuses, rather than just one. So it would show “Done” if Status is either “Complete” or “Archived”

[Kamille_Parks]

augmented:

sometimes when you copy/paste, the double quotes get turned into the wrong type of quotes.

FYI: avoid that by giving people formulas encapsulated in backticks (``) so that IF(“test”) becomes IF("test")

[Raminder_Singh]

For that you need to use the OR function:

IF(OR({Status}="Complete",{Status}="Archived"),"Done",IF(IS_AFTER(TODAY(),{Deadline}),"OVERDUE"))

If you want to extend the formula further, a list of all possible functions is available here: Formula field reference – Airtable Support.