vendredi 28 juin 2019

Google Sheets Query using Checkbox as search criteria

I want to use a query in Google Sheets that lets me look at a column of checkboxes to filter on ones that are checked (TRUE).

QUERY(Available!$A$3:$O, "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,O where O = '"& TEXT(TRUE) &"' and B > 100,000 order by B desc")

It is complaining of a literal value, but I am having a lot of trouble figuring out the proper syntax to ensure the query is reading the checkbox properly.




Aucun commentaire:

Enregistrer un commentaire