I'm completely stuck on this one -- I need to use IMPORTRANGE function but want to make the sheet it pulls from flexible via concatenation -- here is my formula with a scrubbed URL:


This gives me an error "Cannot find range or sheet for imported range"

When I hover over


I receive the correct string:

"'Q1 19.08.19'!$F15"

Moreover, when I try a hard-coded version of the formula:

=importrange("https://docs.google.com/...","'Q1 19.08.19'!$F15")

It provides the correct answer, which makes me think this is a structural issue, rather than my code.

Thanks so much for reading!!


1 Answer 1


On IMPORTRANGE the apostrophes aren't required. Instead of



  • Can I buy you a beer? Thanks : ) Aug 14, 2019 at 13:08

Your Answer

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

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