Filtering out multiple text strings

[bentoben]

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 - https://gyazo.com/6065751e7ed3d0b7f8a1ea2b7e3f5940.

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

[Kamille_Parks]

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.

[kuovonne]

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