Stack Overflow
Stack Overflow

Questions tagged [importrange]

This tag should be used to differentiate questions about the importing of a range of data from other questions on this site. Use when the topic is the IMPORTRANGE function. Should generally be used in conjunction with tag [google-sheets].

276 questions
23
votes
5 answers

How to allow access for importrange function via apps script?

When you enter an importrange function manually into a spreadsheet you receive a pop up and must 'allow access'. However, I'm trying to find a way to do this via a script because I'm creating many spreadsheets, each with a query-importrange function…
Stefan Muntwyler
  • 408
  • 1
  • 4
  • 9
13
votes
4 answers

Combining multiple spreadsheets in one using IMPORTRANGE

I would like to aggregate the data of multiple spreadsheets into one spreadsheet. Spreadsheet 1 has a Row of Strings A2:A500 Spreadsheet 2 has a Row of Strings A2:A500 Spreadsheet 3 is supposed to have a Row of both (Spreadsheet1!A2:A500 AND…
FlorianT.
  • 833
  • 4
  • 14
  • 29
9
votes
1 answer

How frequently does IMPORTRANGE refresh?

How frequently does the importrange function refresh and reload the source data?
Argyll
  • 8,591
  • 4
  • 25
  • 46
8
votes
2 answers

ImportRange Function to Ignore Empty Cells

I want to import a range from another Google sheet, but to ignore empty cells so that the data prints back to back (versus having big gaps created from importing empty cells). Here is my formula (Google link changed for…
Thomas Kauer
  • 81
  • 1
  • 1
  • 3
8
votes
5 answers

How can I make an apps script to instantly allow access to all imported elements in a Google Spreadsheet?

I have to work with google spreadsheets. I am using some template spreadsheets which all contain a lot of links to other spreadsheets. The problem is that whenever I make a copy of the template spreadsheet to use most of the links(created with the…
Daniel Sindrestean
  • 1,153
  • 6
  • 13
7
votes
6 answers

IMPORTRANGE function not refreshing new entries in linked Google sheet

My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having to cut and paste all of the formulae again whenever I want to view the new information. I'm using the new version of Google Sheets…
kjexley
  • 287
  • 2
  • 3
  • 11
6
votes
2 answers

VLOOKUP within IMPORTRANGE

I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP: =importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false))) I get a general error. Does…
Luca
  • 848
  • 1
  • 14
  • 33
5
votes
2 answers

Convert a string to a formula in Google Spreadsheet

I´d been more than 10 hours reading and trying different options with no success. I have this string (this is actually a string that is generated by other…
Gastón BA
  • 53
  • 1
  • 3
5
votes
2 answers

Query returning error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN

I am currently working in the following spreadsheet https://docs.google.com/spreadsheets/d/13KfjUhWSB-BjGyC1G8f8i8o4SPd1kFFLkjN7D6VY8Lk/edit#gid=993210576 In which I am importing data from another worksheet using IMPORTRANGE, and writing a QUERY to…
Dan
  • 53
  • 1
  • 1
  • 5
5
votes
3 answers

How can I force a recalculation of cell using ImportRange function in a Google Spreadsheet?

I have a spreadsheet Target that uses ImportRange to get some data from another spreadsheet Source, as in A6 = query(ImportRange("mykey", "Weekly!B:BI"), CONCATENATE("select * WHERE Col1='",B3,"'"), 0) The select clause is to sub-select the data…
BobC
  • 51
  • 1
  • 2
  • 5
4
votes
2 answers

Google Sheet Named Range Multiple Columns

In Column B I have drinks listed from B2:B100, In Column D I have food items listed from D2:D100. In another google sheet I need to have a single dropdown that needs to pull all the drinks and food items. I created a named range from B2:B100 and…
user3062853
  • 91
  • 1
  • 8
4
votes
1 answer

Triggered functions and IMPORTRANGE

I have a Google Apps Script that compares information submitted in a Google form to information that is brought into the Google spreadsheet using the IMPORTRANGE function. The script works perfectly if I run it manually but if it runs from the form…
user1583290
  • 43
  • 1
  • 3
3
votes
1 answer

Unable to parse query string for Function QUERY parameter

Trying to run this query: =query(IMPORTRANGE("XXXXXXX","'XX'!A:H"), "where Col3 = '666' and select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8 and order by Col5 desc",1) And keep on getting weird errors such as this one Unable to parse query…
user13708028
  • 315
  • 3
  • 13
3
votes
1 answer

Data Validation from another Google Sheet

There is a way to do a data validation between 2 different Google Sheet? I mean, I have 2 different types of Sheets: 1 - Master with all the information 2 - Various Sheets where i import some data from the Master Now, i use the IMPORTRANGE function…
user12742603
3
votes
1 answer

Google Sheets import range returning incorrect data

The full google spread sheet system is used for score keeping and is prone to delays when updating, however I have never run into an issue like this were the same basic function is returning two separate results. The problem is repeatable and occurs…
FootballGuy
  • 33
  • 3
1
2 3
…
18 19