Answer the question
In order to leave comments, you need to log in
Importrange + query = Error?
=query(IMPORTRANGE(" https://docs.google.com/spreadsheets...";"3.0 Deals GF!A1:Z"), "select * where Col6 contains 'K1P1'")
Why does it give a syntax error?
Perhaps there are other suggestions on how to import data with a condition?
Answer the question
In order to leave comments, you need to log in
1) Try to quote the sheet name with
'3.0 GF Deals'!A1:Z
2) If the locale does not require a comma as a separator, then most likely you need to put a semicolon there (for the Russian locale by default). There is definitely a wrong delimiter somewhere - the formula contains both a dot and a semicolon at the same time
...GF!A1:Z") , "select ...
i.e. try in the end
=query(IMPORTRANGE("https://docs.google.com/spreadsheets...";"'3.0 Сделки GF'!A1:Z"); "select * where Col6 contains 'К1П1'")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question