R
R
RomanCap2022-01-25 23:35:18
Google Chrome
RomanCap, 2022-01-25 23:35:18

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 answer(s)
G
Grigory Boev, 2022-01-26
@ProgrammerForever

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 question

Ask a Question

731 491 924 answers to any question