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