1

I am trying to combine 3 different sheets of data from range A2:O Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 using Query({IMPORTRANGE(... function. I tried using the formula below but it's saying

formula parse error

https://docs.google.com/spreadsheets/d/1ECEMY6zdrIHrtJhvwLm0XnyP4AYOp4YnZ_bp9azLNyM/edit?usp=sharing

=QUERY( 
{ 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O"); 

IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O"); 

IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O"); }, 

"Select Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 ORDER BY Col1 ASC",1 )
2

1 Answer 1

0

As mentioned here and the comments alike, you should:
First authorize the function IMPORTRANGE and then use it within the QUERY

Also, since you stack open end columns (A2:O) instead of closed end (like A2:O33) it is a good idea to constrain the results by using something as simple as WHERE Col1<>'' in your query.

Summarizing, your query would be:

=QUERY( 
{ 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O") }, 
"Select Col1, Col2, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 WHERE Col1 <>'' ORDER BY Col1 ASC",1 )

1
  • Did this answer work for you? If not why? If yes, as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well -. (Why vote?) Sep 3, 2019 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.