I’ve gone crazy trying to figure this one out (as it seems like it should be so simple) and hoping to get a helping hand.
I’m trying to create a table that is filtered based off 3 different dropdowns. The dropdowns match to the columns with the same names.
Ideal State Example: [User wants to see a small size, CL with a goal that is acquire] User select each of the dropdowns. The table then displays any rows containing Small, any rows containing CL, and any rows containing Acquire all in one view.
The challenges I’ve run into with this:
- Matching identification - the formulas I’ve used do not properly detect all of the keywords (ex. With ‘small’ it only pulls exactly ‘small’, not ‘small, medium’) or they add other keywords that should be omitted, like ‘large’
- Filters not playing nice - formulas canceling each other out when trying to filter. ex. Size works but then is cleared when Cover is added
Added bonus: if anyone has a trick to show All Rows when none of the dropdowns are selected, that would be amazing.
Appreciate any help or insight. Thank you in advance!