google sheetsimportrange
I’m trying to get IMPORTRANGE to work for me with no success. I made two simple spreadsheets: Destination Sheet and Source Sheet. In the destination sheet I’m using the import range function:
=importrange(“1-5F1_zz0ZpGj7SfeQhewsCe0CsrA0eyPbjfmUrLBsyk”,”Sheet1!a1:a1”)
I tried already:
Not sure what else to do.
Any ideas?
Seems to work for me:
Your formula is in K4. Maybe the first part of what you are concatenating has to be a valid address itself?
I've been struggling with the same problem. Instead of writing a custom function, I add a different query string to spreadsheet_url in IMPORTRANGE in the hope that each time the page is refreshed, Google thinks it needs to fetch data from a new spreadsheet. I simply append a new timestamp to make the url unique each time. It's a blatant hack, but it has been working for me across a lot of sheets.
My formula previously looked something like:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/123123123123/edit#gid=1816927174","'Sheet1'!A1:B25")
And now it looks like:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/123123123123/edit#gid=1816927174"&"?"&now(),"'Sheet1'!A1:B25")
This method no longer works since Google no longer permits now() inside importrange(). See comment from Hugh below.
Best Answer
The following are three distinct characters:
and although the help file for IMPORTRANGE mentions only ...either be enclosed in quotation marks or be a reference to a cell containing... the required quotation marks are the "straight" ones.
So just use
".