New answers tagged importrange
2
I followed the link Automatically "Allow Access" for IMPORTRANGEs in Google Sheets? StackExchange added to the discussion, and learned something new:
You actually DON'T HAVE TO specify the Tab name in IMPORTRANGE! This formula actually works:
=IMPORTRANGE([URL],"A1")
It imports cell A1 from the leftmost visible Tab in the document at [URL]...
1
From the question
Can a Script distinguish IMPORTRANGE N/As due to non-existent Tabs from N/As due to not having access permissions?
, but I wonder, might there be some way a Script could distinguish between the two, and return a specific result once the docs are connected?
No, but you could use a script to check if the sheet exists.
var spreadsheet = ...
1
Judging from your formula, February or January must be tab names belonging to the spreadsheet.
If that is the case, use the following syntax
=query(importrange("1L86iP0GLHTubwfvxs1kJ4ocbmgRAd4Iz0000000M", C1&"!A2:F"),"Select Col6, Col5 where Col1 is not null",0)
where cell C1 has a value of February or January or...
(If ...
Top 50 recent answers are included
Related Tags
importrange × 190google-sheets × 188
google-sheets-query × 78
formulas × 57
google-sheets-arrayformula × 19
google-apps-script × 14
vlookup × 7
filter × 5
google-sheets-custom-function × 4
conditional-formatting × 3
google-sheets-dates × 3
concatenate × 3
pivot-table × 3
import × 2
importxml × 2
importhtml × 2
regexextract × 2
google-sheets-filter × 2
google-drive × 1
google-apps × 1
google-forms × 1
security × 1
formatting × 1
permissions × 1
automation × 1