mercredi 20 mai 2020

Query combined with filter regarding checkboxes values

I would like to query with multiple filter criteria based on checkboxes conditions. For instance, I can filter item by item checked, ok, but I would like to combine filter in that same query result by getting out all the items correspinding to the value in the following column of checked checkboxes.

Something like =query(A2:I;"select G, H, I where D = TRUE" & IF (A=TRUE;; WHERE I = filter(A2:B;A2:A=TRUE) ))

Thank you for your help. Here's the sheet : https://docs.google.com/spreadsheets/d/1qk3R2N9Pi0gnnJpNKPMk_WGI2Fh_fBHUgrXMS2fUy9k/edit#gid=388552420




Aucun commentaire:

Enregistrer un commentaire