Hi All - I am dying here just trying to search filter my Airtable records based on a Status column.
It would be a Christmas Miracle if I could get this working today
I have tried so many different things but I think the issue is I have no reference to the returned data so there is no way to filter.
Goal: Very simple Status != “Done”
I have tried
{Status}!=“Done”
{Status}!=‘Done’
IF({Status}!=‘Done’, true, false) - Same with double quotes
I have tried with and without Output fields checked or mapped
Each time I get a RuntimeError
[422] The formula for filtering records is invalid: Unknown field names: true
Gotta love when you walk away for a moment and come back - use a little ChatGPT (which I originally tired)
Ok here is the Rub:
Need to only select the Output field you want to filter on and the following worked for me
Status != "Done"
With the spaces and double quotes. 
realized I needed more fields from Airtable later on and selected all and it still worked - not sure why this didnt work for me last night
Hello @Scottinabox,
Instead of that try this
AND({Status}='Done')
Instead of AND you can use OR, SEARCH, or REGEX_MATCH. But it all depends on the requirements.
The things you’ve tried were not matched with the Airtable formula structure.
You need to match with airtable formula syntax.
Read more on these help docs and community articles.
