Stack Exchange Network

Stack Exchange network consists of 174 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
8 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
18 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
12 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
31 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
17 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
26 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
26 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
27 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
14 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
33 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
55 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
25 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
31 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
20 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
295 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
211 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
52 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
425 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 ...
0
votes
1answer
338 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
622 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 ...
0
votes
1answer
22 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
1k 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
1k 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
335 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
820 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
410 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
4k 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
847 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
179 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 ...
0
votes
1answer
356 views

Import specific columns from another Google sheet

I used this query after studying from Google: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_Mh5lEqBh1OBzuW5U1Fvr1MK_6doIvKmV23YKp4Fu0c/edit#gid=529591601","'iOS'!E:G"), "Select Col4",1)...
1
vote
2answers
18k views

Help with a “=QUERY(IMPORTRANGE(…” formula in Google Sheets

Having trouble with a =QUERY(IMPORTRANGE(... formula in grabbing a value from a single cell in another sheet, but only in the row where a particular text value exists in another column in that row. I ...
0
votes
3answers
4k views

VLOOKUP using cell reference with IMPORTRANGE gives error

I can't see what I'm doing wrong with this. This Doesn't Work =Vlookup(L2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_Le0cMfbHRSgXqhCdzjQrBscFNm6p1sL-DowWdCZ0Fs/edit#gid=1761671943","...
0
votes
1answer
1k views

Importing cell color with IMPORTRANGE

I need not only to import the data from a cell, but also the cell background color. I've found ways to import color, but it's usually on a 1:1 basis (for example A1 color from the source gets copied ...
1
vote
0answers
102 views

Notify of user edits and not of IMPORTRANGE edits

(I think protect sheets/range will help here but besides that.) Let's say I have a sheet called Alcohol that imports from other sheets Tissue, Pencil and Physics and is editable by other users. How ...
0
votes
1answer
1k views

Is there a way to use IMPORTRANGE within an array formula and for this to be dynamic?

I'm trying to pull spreadsheet IDs from another sheet's range with equal dimensions, and then using those to pull data from spreadsheets with those IDs. I want to use an array formula to auto fill a ...
0
votes
1answer
377 views

How to import only sheets with specific text in the name?

I'm using this script but it takes all sheets of current spreadsheet. A bit modified script from original, but it doesn't achieve what I want: function importallMain() { var id = 'some id'; var ...
-1
votes
1answer
38 views

Is there a Google Sheets functions equivalent of mysql_fetch_row? [duplicate]

Is there any way to get the row result in Google just like mysql_fetch_row that returns only the row base on query statement? I hope there has a formula for this. Using this formula =Query(...
1
vote
1answer
2k views

Trigger function when IMPORTRANGE() is updated

I have a sheet (sheet-A) that gets it's information from another sheet (sheet-B) using IMPORTRANGE(). In sheet-B I have a function that formats cells based on the a value in the row. At the moment I ...
0
votes
1answer
217 views

After a Google Sheets update IMPORTRANGE errors everywhere

I noticed that on Monday (2/13/17) Google made an update to Google Sheets, the filters are now a different color (green). After this update, the IMPORTRANGE function has just been volatile. It doesn't ...
0
votes
1answer
1k views

Using QUERY to filter multiple criteria from another spreadsheet

I have a column with 3 options: Primary Secondary [empty cell] I am currently using this formula to filter all rows that contain "Primary" from one spreadsheet to another and it's working well. =...
4
votes
2answers
4k views

How can I import a column from one sheet into another sheet of the same Google Sheets spreadsheet?

I don't look for =ImportRange because I want to stay within the same Google Sheets spreadsheet. Instead, I want to import a column from one sheet into a column of another sheet within the same ...
3
votes
1answer
4k views

Google Sheets Query group by multiple

My sheet is here, and we are looking on the sheet called "Paste". I would like a query that finds and sums the total dollar amounts when the same customer receives the same service code more than ...
1
vote
1answer
177 views

Evaluate date inside a query

I am attempting to perform a query in Google Sheets, and one of the things I need to match is a date. I have seen other posts on this topic, but I am not having success. The advice that isn't ...
1
vote
1answer
356 views

How can I import rows from one mastersheet to another sheet where row has value “test”?

Mastersheet name: Recherche. Sheet name where the data has to be copied to: Leads. Mastersheet has data filled from Column A4 to Column M4 (both going down to 1,000 rows), looking like this: ...
0
votes
2answers
250 views

QUERY() ignores query when combined with array

Please consider the following Google Spreadsheet Formula: =QUERY( ARRAYFORMULA({ IMPORTRANGE("f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU","Sample!A1:A"), IMPORTRANGE("...
0
votes
1answer
1k views

I cannot get the QUERY function to work with IMPORTRANGE

I am using the function below to QUERY an IMPORTRANGE range based on IS NOT NULL conditions: =query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O5DeZ9LFLpGbp8b2aGst57XLEP7ZiOnc-2b552sQLz0","...
3
votes
1answer
3k views

How to use IMPORTRANGE with a variable range-string pulled from a cell?

I'm trying to create a user friendly sheet where data is pulled from a different Google Sheets based on input from the user. So far I have this working: =IMPORTRANGE(C40,"2016 Data!W2:W13") Where ...
1
vote
1answer
2k views

IMPORTRANGE and Query say column does not exist

I want to get the sum of hours an employee, whose name is in Cell D1, was absent by referring to a table. The table is on a sheet named Sep. The word Sep is a string typed in A97. I am able to ...
2
votes
5answers
12k views

IMPORTRANGE() will not update unless deleted and re-pasted

IMPORTRANGE is not updating on one of my sheets. I've been using it on hundreds of other sheets with no update issues but it is no longer functioning for me. The sheet is set to update every minute I ...