Help

Re: What am I doing wrong? IF / AND statement

2320 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Lidell
5 - Automation Enthusiast
5 - Automation Enthusiast

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"),"","")

Alex_Lidell
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Alex_Lidell
5 - Automation Enthusiast
5 - Automation Enthusiast

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.