1

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. – marikamitsos Dec 19 '19 at 10:38
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

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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