I am new to the free version of Airtable which I am using to keep track of my craft stamps. I have at the moment around 500 items which have sentiments listed. When I try to find a particular sentiment I search for eg has any of, but it gives me "enter comparison value" and all the sentiments I have created. What I want is just a search box so I can just type just one word eg happy, so all those sentiments are found. What have I done wrong please and how can I rectify it.
Filtering

Best answer by TheTimeSavingCo
Sorry how do I filter by status? I don’t seem to have that option .
I’m using the free version would that matter?
re: Sorry how do I filter by status? I don’t seem to have that option .
Ah, here are some step by step instructions, sorry for the confusion!
1. Create a 'Formula' type field: https://support.airtable.com/docs/formula-field-reference
2. In that field, reference the 'Sentiment' field. It should look like this:

3. In your filters, use that new formula field which should now let you filter by 'contains': 

---
re: I’m using the free version would that matter?
Nope, wouldn't matter!
===
I'd also suggest checking out the Airtable academy to familiarize yourself with some of the functionality if possible! https://academy.airtable.com/
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.