I'm trying to run a query (IMPORTRANGE) formula in a new Google sheet. The data I'm trying to load is from another sheet. The source sheet contains 6,000 rows and 12 columns. I tried:
=QUERY(IMPORTRANGE("SHEET_KEY","Sheet1!A:C"),"select Col1")
The result is #REF!
and when I hover over the cell there is no additional information.
I also tried the IMPORTRANGE formula separately and it's loading the data correctly. I tried the exact same query in a new tab in the source sheet:
=QUERY(Sheet1!A:C,"select A")
and the data was loaded successfully, however I need to run the query formula in a new Google sheet.
IMPORTRANGE("SHEET_KEY","Sheet1!A:C")