When I use the syntax:
=query(Clients!A:J,"select H where (H='Yes')",-1)
I only get "Assigned" as a result, no # of records.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
=query(Clients!A:J,"select H where H contains 'Yes'",-1)
More of a syntax error.
= checks whether it is exactly equal and might contain errors.
contains should do the trick.