Is there a way to filter by whether or not an entry contains xx? I want to be able to tag entries with more than one tag, and then to find them based on one particular tag.
Also, I’m not a programmer so be gentle.
Many thanks!
Hi @Catherine_Berry !
A Choice List column might be useful here if you are using tags. The choice values could be your tags and then you can use use the built-in filter to filter for records that contain a specific tag(s). In the screenshot below, the column is filtered to only show records that contain tags B and C.
Excluding specific tags wouldn’t be quite as easy. If you exclude a value from the filter, it will exclude records that only contain that value.
You can use a formula to filter with more specificity. I created an example here: Community #7657 - Grist
I added a card at the top where you select which values you want to include in the filter and which you want to exclude. In the screenshot, I want records that contain A or B but exclude C, if so, the Filter column returns true. If a record includes C and not A or B, then it returns false. You can then apply a filter to this filter column to only show the records you want based on the Include/Exclude values you have listed.
No need to be a programmer to write formulas. I’m not a programmer either - I actually used our Formula AI Assistant to write this. Here’s a snapshot of what I asked to get the formula output. I gave it all of the information I could.
Finally, apply a filter to the Filter column to only show true values.
Please let me know if you have any follow up questions!
Thanks,
Natalie