Please use the following query formula:
=QUERY('R&MCollections'!J1:Q," SELECT * WHERE P = TRUE ")
(you can change ranges to your needs)
Normally, when referring to text, the
WHERE clause should be wrapped with single quotes
But, when the clause depends on a Tick box, we MUST NOT use the single quotes.
As an example:
If one would look for John the
WHERE clause should be
WHERE P = 'John'