I’ve got a Google Sheet with data (Columns A,B,C), a dropdown list (E) and source for this dropdown list (G)
https://docs.google.com/spreadsheets/d/1XY5Nfwi-DtXIV7PMkhax_60EpX5puawmUF-fl2qvEqk/edit?usp=sharing
I use an AppScript to allow multiple selection on this dropdown and separated by a coma (,).
I need to make a QUERY to get All line where at least one of value in selected value from dropdown list is containing by one or more users.
Ex. If I choose A, B … Jean, Patrick and Fabrice will be shown as result !
It’s a Query with OR not AND (after I’ll had a way to choose between ‘Or’ and ‘And’
I know how to make a query from a value in a dropdown list … but if more than one value is selected I don’t know how to do this
Thanks for your help