I want to filter Airtable records that meet 2 conditions: recordstatus = “new” and date_planned = today. So my formula is:
The second part of this statement is executed perfectly (even if I manually change the date in Airtable), but the first part is ignored; there is no record with “new” for a recordstatus.
Even in make.com, it seems that the first part is ignored, but the result only shows the second part.
I must be doing something silly, but what?
You’re not silly this is a common problem when filtering Airtable records using formulas, especially with text values and IF logic in platforms like Make.com.
Here’s what’s likely going wrong and how to fix it:
The Problem
Your formula is probably something like:
airtable
AND({recordstatus} = “new”, {date_planned} = TODAY())
But:
"new" might have extra whitespace, like " new" or "New" (case-sensitive).{recordstatus} might be a Single Select field, and = "new" does not work the same way as with plain text.Hi, thanks for the quick reply!
I double checked for spaces and there are none. And {recordstatus} is a Single Line Text… 