What am I doing wrong? IF / AND statement

[Alex_Lidell]

I am monitoring a project. It has a field for due date (DUE) and a dropdown select field for status (STATUS). I would like to create a formula that would alert me if the Due Date has passed but the task STATUS is anything except “complete”. I am trying this formula but its not working:

IF(AND(IS_BEFORE({Due},TODAY(),STATUS!=complete),‘ :x: ’,‘ :white_check_mark: ’)

What am I doing wrong? Please help a newbie. Thank you in advance!

[ScottWorld]

Try this:

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

[Alex_Lidell]

@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

[ScottWorld]

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

[Alex_Lidell]

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

[ScottWorld]

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

[Alex_Lidell]

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

[ScottWorld]

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

[kuovonne]

ScottWorld:

Airtable always expects " when referencing strings. Airtable only uses ' when the function specifically calls for it

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.