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!
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.