What am I doing wrong? IF / AND statement

Try this:

IF(AND(IS_BEFORE({Due},TODAY()),STATUS!="complete"),"❌","✅")

@scottworld - didn’t work :frowning: It marked all records with a past due date as problematic, including those that were complete. So it ignored the Status part

I forgot to change your single quotes to double quotes. I’ve edited it above.

Same problem… I don’t for the life of me understand why its not taking the status into account.

I would check the spelling of “complete”, including capitalization.

YES!!! THAT worked!!! Thank you. I didn’t realize capitalization mattered. How did you know to use " instead of ’ in this case?

You’re welcome! Airtable always expects " when referencing strings. Airtable only uses ' when the function specifically calls for it (for example, when using the DATETIME_FORMAT function).

Airtable formulas can use either single or double quotes (' or ") in the same way as most programming languages. It is useful to alternate the quote type when you want to use a literal quote without having to escape it.