I have a sheet that has 5 columns, with what I will "Features" - Vegan, Non GMO, Soy Free, Dairy Free, Gluten Free.
For each product entry, I have setup simple true/false data validation based on whether that product meets the metric.
To the right, you can see a "Features" column. What I want to do is create a filter on that features column that will display products on a website based on whether any metric is meet, ie whether the product is vegan, non gmo etc
You can see what im trying to do over at VitaminSpecs. You can see the last filter currently returns "null" due to no data, but thats where I want to list "Vegan" "Non GMO" etc and allow customers to be able to multi-select those metrics
Update: From the formula provided by Player0, I am able to generate the following in the spreadsheet and on website
CodePudding user response：
try in T2:
=INDEX(REGEXREPLACE(TRIM(FLATTEN(QUERY(TRANSPOSE(
IF(O2:S=TRUE, O1:S1&",", )),,9^9))), ",$", ))
CodePudding user response：
Cant seem to add the latest images to original post. Coming up with some code indentation error thing.
