CODEWITHSUNDEEP
excelgoogle-sheetsgoogle-sheets-formula
JKau
JKau

Reputation: 33

Why does IMPORTRANGE not import data from a formula?

I am using IMPORTRANGE in Google Sheets to copy data from a "data prep" sheet to a sheet my sales team uses. Somehow in one of the IMPORTRANGES it does import everything but the data that I added with a formula.

Formula is:

`=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1VWprxZwaMoHmA1X7xyW-ZQW-mVL01uM8s72qlnTAWvc/edit","Input Buyers!A:E")`

Googles Example Formula is:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg/edit", "World Cup!A1:D21")

Is this a known issue? Seems super esoteric as I have other IMPORTRANGES where this works.

Screenshot for detailed explanation:

Left is the data prep sheet, right is importing. You can see the IMPORTRANGE on right A1 including the correct ULR and range. On the left D2 has a formula (where I match the owner with the buyer) in the top version and just text in the bottom version. In the top it does not import the owner, in the bottom it does.

enter image description here

Upvotes: 0

Views: 2293

Answers (2)

Bruno Gomes
Bruno Gomes

Reputation: 1

You can change the data format in the source sheet. I had the same issue and changing from 'Automatic' to 'Text' worked just fine.

Upvotes: 0

GoranK
GoranK

Reputation: 1668

It seems that quotes around the sheet name are missing.

=IMPORTRANGE("LINK to Sheet","'Input Buyers'!A:E")

instead of

=IMPORTRANGE("LINK to Sheet","Input Buyers!A:E")

Upvotes: 1

Related Questions