Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [importrange]

This tag should be used to differentiate questions about the importation 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 a tag for a specific app.

0
votes
1answer
10 views

How to use IMPORTRANGE when I have multiple tabs?

I have to export some data from a Sheet with 30 tabs(a tab for each day of the months) and I have to extract data under specific criteria from all the sheets which have to be done every month on a new ...
0
votes
1answer
12 views

How to import/merge data from from 2 separate sheets from another spreadsheet

I need to import data from "Spreadsheet A" to "Spreadsheet B" but all the data is in two separate sheets "MY" and "NY" in "Spreadsheet A" I basically need exactly this but with a function to import ...
1
vote
1answer
12 views

Google Sheets Query Where Cell value

I'm looking for help editing a Google Sheets formula. I want the formula to Import Range from another worksheet where value equals a specified cell. I can only make the where in the formula equal a ...
0
votes
2answers
17 views

Applying IMPORTRANGE formula in Google Sheets between tabs

I have one Google sheet having three tabs, Sheet 1, Sheet 2, Sheet 3. I have another tab having the name "Sheet 4" in which I want to import all data from these three tabs, but the problem is data in ...
1
vote
1answer
21 views

Query(Importrange) or Query with dates

I am trying to show or limit what is seen to just entries made in 2019. I found a few places that referenced this and have tried the following without success. =query(IMPORTRANGE("1bSyor-...
0
votes
1answer
34 views

ImportXML not stable in Google Sheets, how can I improve that?

I have ImportXML in my spreadsheet. I am tracking the Alexa ranking of a list of websites. Here is the formula: =HYPERLINK(CONCAT("www.alexa.com/siteinfo/",A4), value(ImportXML(CONCATENATE("http://...
0
votes
1answer
45 views

Equivalent of IMPORTRANGE with script in Google Sheets [closed]

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script? ={IMPORTRANGE("SheetKey","SheetName1!A:J") ; IMPORTRANGE("SheetKey","...
0
votes
1answer
9 views

Force `imortrange()' to update data

I'm using the importrange() formula inside of Google Sheets to import a bunch of data from multiple spreadsheets into one sheet. On this one sheet I'm using circa 20 importrange() formula's each ...
0
votes
1answer
13 views

How to use a cell value to define the sheet on IMPORTRANGE

Trying to create a spreadsheet that reads values from a certain sheet of another file using importrange formula. I am trying that the referenced external cell be a cell on the current one so I could ...
0
votes
1answer
18 views

Importrange doesn't import data from extensive sheets

The formula works on lower column number that I need to get data from but nothing is happening when I need to import data from columns with a higher number. Following formula works (data imported ...
0
votes
1answer
28 views

Linking a dynamic inventory price list to another file in Google Sheets

I've got a master inventory price sheet for all the ingredients we use in our recipes that I want to reference in all our recipe files to dynamically calculate costs. This way if we change suppliers ...
1
vote
1answer
95 views

Using filter and importrange to get a value from Col8 when some of the rows in Col1 are subheadings

I just want to return the value in Col8 corresponding to the row that has "Residential". I can only seem to get the value that is in the top row rather than the row corresponding with "Residential". =...
0
votes
1answer
42 views

ImportRange not pulling in Dates from first sheet in correct format

I'm trying to pull in a date cell from one sheet to another with an importrange function: =iferror(query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UClhpev01z-...
0
votes
1answer
38 views

Use of IMPORTRANGE to juxtapose variable-length lists

Let's say I have two Google sheets, Doc1 and Doc2, both having only one sheet featuring two lists with the same schema, say two columns Name and Age. The lists have an unknown number of entries, but ...
0
votes
1answer
601 views

FILTER has mismatched range size; referencing the second last cell in a column in range

I am using a multicriteria filter to check if my sheet contains a certain value combination. The formula should automatically include any new rows added to the sheet. However, if I do it this way: =...
0
votes
1answer
32 views

Inaccurate output when using importrange vs manual input

I have a little problem using Google Sheets. I'm using importrange to get raw data from another sheet that I don't own. This is the sample raw data, then import it my own sheet here. Importing data ...
1
vote
1answer
131 views

Conditional IMPORTRANGE

In Google Sheets, I'm using IMPORTRANGE to pull in data from to a large sheet. One field is a dollar amount. I would like to import the dollar amount and replace any zero amount with a specific ...
0
votes
1answer
126 views

Getting data from another Google sheet that isn't in the same order

I have a very basic knowledge of deeper functions of Google sheets and solving this has been a little bit of pain in the butt so far. I have a spreadsheet A column A contains ID column I that has ...
0
votes
1answer
581 views

QUERY error NO_COLUMN:col1

=query(importrange("12HAbnTv4g_6m1UeCOs9ZO0gAYvy8tlaXr-cc2ecPEic","Master!A:ba"), "select col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col53 where col53<> ...
0
votes
1answer
17 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is a loading time and this ensures that the cells are empty during loading. Because my formula ...
1
vote
1answer
205 views

Combining 3x IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with: Sheet 1: 480 rows Sheet 2: 40 rows Sheet 3: 20 rows The sheet keeps expanding by the day since the sheet's data comes from a Google Form ...
1
vote
1answer
19 views

How to insert cell text from one cell into an ImportRange Function

Hello! so I have an issue where I am trying to do is have multiple functions in C, D, and E where a link is required. Instead of copying and pasting the link inside all the functions in specific ...
1
vote
2answers
392 views

Using QUERY and IMPORTRANGE to pull records from a specific date range

I have created two spreadsheets. This one is my source data: https://docs.google.com/spreadsheet_A And I would like this one to just be the people who are currently here (so Column D < today and ...
1
vote
1answer
245 views

Query Importrange with multiple values

This formula is working fine, but I need to add in other teams into Column A. I would need to return ATT SLC, ATT Orem, and ATT Scottsdale within this same range, but I'm not sure the language to use ...
3
votes
1answer
40 views

What spreadsheets import from my spreadsheet?

Is it possible to get a list of the spreadsheets that are importing data from my sheet? I maintain a spreadsheet that has raw data, and many other spreadsheets use IMPORTRANGE to import that data. I ...
0
votes
0answers
52 views

Change an entire google sheets to UPPER case, not with an add-on or onEdit(e)

I need to change all the text in a google sheets to upper case, the problem is it's filled in by Zapier which doesn't register as an edit for onEdit functions. It's also automatically converted to ....
0
votes
1answer
579 views

How to reference a Google Sheet by filename?

How to reference a Google Sheet by filename? I would like to use IMPORTRANGE function, but it can only reference a file by URL not by filename. Example filename: 2018-11.xlsx 2018-12.xlsx
0
votes
0answers
41 views

Automatically import a range from a different Google Sheet at HOURLY intervals

In a google sheet, I have a dynamically changing cell that updates production every few minutes. Each hour, I want to pull the new number to my alternative sheet, so that I may get the total ...
0
votes
1answer
556 views

How to Fix Error in Multiple Importrange

I am creating a table to display data from a combination of several Spreadsheet files by using Multiple Importrange. = QUERY ({Importrange (G3, "Sheet1! A2: D"); Importrange (G4, "Sheet1! A2: D"); ...
0
votes
1answer
143 views

Set formula into a cell based on content of another cell?

Google Sheets: I would like to set a formula into a cell, but this should depend on content of another cell. Example Google Sheet (anybody can edit): https://docs.google.com/spreadsheets/d/...
-1
votes
1answer
59 views

Setting ImportRange on a delay

Is it possible to set a timer or delay for the importrange function on Google Sheets?
1
vote
2answers
257 views

Restrict ImportRange to only visible rows

I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped. =importrange("WorkbookID","Sheet1!A2:K13285")
0
votes
1answer
24 views

Google Sheets Query Searching?

I'm trying to run a Query on some data that's being imported, and have it only Bring data over that matches the Email in the document. This is my code: =QUERY(IMPORTRANGE("SHEET ID REMOVED","'Form ...
1
vote
1answer
723 views

IMPORTRANGE syntax when using query on multiple tabs

I am using IMPORTRANGE within a query to extract data from sheet 1 to sheet 2. The following code is in a cell in tab A of sheet 2, and works as intended: =query(importrange("URL-A","E:J"), "select * ...
0
votes
1answer
426 views

Google Sheets - Importrange

Currently we have one summary sheet called Order_Summary which collects data, one day per column and someone at work creates a new column daily. We now have another google sheet which now records an ...
0
votes
1answer
367 views

Date Query in Google Sheets with importrange

I have two tables. Table A= Customer Feedback Table B= KPI In Table A I have a column for a date with format mm/dd/yyyy and in Table B I have 2 columns as from date and to date with the format. I ...
1
vote
1answer
840 views

Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE - use ARRAY or VLOOKUP?

I add/deleted/move rows frequently in my workbooks. When I add/remove rows from Spreadsheet#1 ("S1"), I need the referenced cell in Spreadsheet#2 ("S2") to dynamically update so it still references ...
-1
votes
1answer
801 views

IMPORTRANGE row limit?

I have a document where I am trying to mirror some data from one Google sheet to another. I have over 1000 rows in the first document; when I use the IMPORTRANGE formula it works fine as long as the ...
1
vote
1answer
1k views

Does IMPORTRANGE automatically update the destination if the source is changed?

Not sure if this has been answered else ware but, I'm trying to use the importrange function in Sheets to import a list of dates from spreadsheet A to spreadsheet B. That part works fine, however, if ...
1
vote
1answer
329 views

Copying values between Google Sheets

I have 2 Google Sheets. I have data on Google Sheet A and I would like it to automatically transfer some values to Google Sheet b. For example, I have some email addresses and some data associated ...
0
votes
1answer
23 views

Can we use Column Range for Comparison in Google Spreadsheets Query?

Suppose I have a table with 3 columns in a Google Spreadsheets sheet. Col1 is a name and Col2 and Col3 are numbers. Can we use a column range for number comparison such as in the example below? (what ...
3
votes
2answers
2k views

Google Sheets Query(Importrange) with named range?

I am looking for a way to query an imported range using named range. Something similar to this, however I cannot makeit to work Sheet ID#A has a column J whose named range is "Signed" that may ...
0
votes
1answer
2k views

Using Query and Importrange to pull Google Form data from one worksheet to another

This is the query code I'm using to get form responses filtered to pull only a specific user ID from a google form in one Google Sheets workbook into another workbook: =QUERY(IMPORTRANGE("KEYID#","...
0
votes
1answer
447 views

Add numerical condition to Google Sheets QUERY with IMPORTRANGE

I am using IMPORTRANGE to call and organise some data from another Google Sheet: =QUERY(IMPORTRANGE("key", "Sheet1!A2:I"), "select Col1, Col2 where Col2 is not null order by Col2") How can I add the ...
0
votes
1answer
1k views

Compare dates in query from IMPORTRANGE and cell

for a few days I'm stuck at comparing two dates. In a big table with dates as columns and products as rows, we want to display the amount of sales per day per product. What the following query does: ...
1
vote
1answer
2k views

importrange with query not working properly

I'm trying to import a column from a separate sheet and add a query to it. Im using: =QUERY(ImportRange("URL","SHEETNAME!c:f"),"select Col1 where Col4 contains 'statements' ") I've been using this ...
1
vote
1answer
551 views

Reference entire row data or row-by-value from other sheets

I've a Google Spreadsheet where my first sheet is a Products table. The columns are SKU, Title, Price, Category, Type I've some tasks in front of me where I need to create some bundles of different ...
2
votes
1answer
6k views

Google Sheets Filter Multi Column List With Another List Using A Function

I have two lists (A and B). I want to filter list "A" (a multi column list) with values in list "B" to create a Final List, list "C". List "A" has multiple records for each student ID number. List "B"...
1
vote
1answer
1k views

Problem with IMPORTRANGE function in Google Sheets

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: =...
2
votes
1answer
222 views

How to use a function in a Google sheet parameter

I am using function IMPORTRANGE as follows: =importRange("https://docs.google.com/spreadsheets/d/SPREADSHEETKEY/edit", "2017!D4") which works great. Now I need to substitute the D4 in my parameter ...