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.