Search code examples
google-sheetsgoogle-sheets-formulaimportrange

Why is this IMPORTRANGE formula not working?

I keep getting an error while using the IMPORTRANGE formula:

=importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”, “Sheet1!A:B”)

I changed the name of my sheets several times to make sure everything matches but see a:

Formula parse error

and I am not sure what I am doing wrong. The original sheet has several tabs as well.

Can you see where the error is?

Solution

  • This worked for me:

    =importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”; “Sheet1!A:B”)

    Maybe try it with a semicolon