Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

What am I doing wrong? IF / AND statement

Topic Labels: Formulas
431 8
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

8 Replies 8

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.