Re: Filtering out multiple text strings

506 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

We have a field called Brands and we’d like to filter out several brands from showing going forward. Instead of adding each brand name as a filter itself in the View, we tried playing around on filtering out by creating a new formula field, and add more brands as we go into that field formula, to no avail.

Here’s the formula -

What’s being done wrong? Thanks for your help and time!

2 Replies 2

Have you considered making a Table for [Brands], and turning that SingleLineText field into a LinkToAnotherRecord field pointing at the brands table? That way you could have a a Checkbox field in [Brands] to mark if the brand should be included. Then you could replace your formula field with a Lookup field pointing to that Checkbox and use it for the filter.

Can you post a screen capture showing your field setup and desired output?