I have a checkbox in Column R. (values are TRUE OR FASLE).

I want a dynamic query. I will ask the user to select a value in B2 where "true" or "false" is selected.

The below query is working (no error) , but not fetching any records.

=query(Plan!C:AU,"select C,D,E,I, L,M,N,F,G where I>0 and G= '" & $A$2 & "' and R ='" & $B$2 & "' order by L label L 'QC Dt' ",1)

The Query is working well for Column G from what is selected in A2. It is normal text value.

But, how to use it for a logical variable?

  • Please share a test sheet with dummy data and the expected solution. Commented Dec 19, 2019 at 10:38

1 Answer 1


Please try changing your formula to:

=query(Plan!C:AU,"select C,D,E,I,L,M,N,F,G where I>0 and G= '" & $A$2 & "' and R=TRUE order by L label L 'QC Dt' ",1)

Bassically change R ='" & $B$2 & "' to R=TRUE


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.