I need help with Google Sheets

Get Help
#1

What is wrong with this code?

It is supposed to only gather the data in the is range for cols 1,2,3,5,11 for the name Bob that contain False. In my results I’m getting data that are TRUE. If I change 'not Col25 = ‘True’ to Col25 = ‘False’, I get no results at all.

=QUERY(IMPORTRANGE(" "Master!A:AB"), 
 "select Col1,Col2,Col3,Col5,Col11 
  where Col11 = 'Bob'
  AND not Col25 = 'TRUE'")
#2

Welcome to the forums.
I didn’t know you could use SELECT in a QUERY(IMPORTRANGE function. Now I know. :slight_smile:

Usually, it’s something like this: =QUERY(IMPORTRANGE("spreadsheet_url", "data_range"), "query_string")

This might be helpful:

https://blog.coupler.io/query-importrange/#Using_QUERY_and_IMPORTRANGE_together

1 Like