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

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
0answers
22 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
13 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
34 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
vote
1answer
36 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
57 views

Question about the importrange function in Google Sheets

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
17 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 ...
0
votes
1answer
625 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
427 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
110 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
530 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
859 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
0answers
246 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
2k 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
517 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
124 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
256 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
11k 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
2answers
2k views

VLOOKUP using cell reference with IMPORTRANGE gives error “Did not find …”

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
889 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
74 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
944 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
337 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
33 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
1k 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
171 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
870 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
1k 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
3k 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
141 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
311 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
155 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
720 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
2k 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 ...
1
vote
3answers
8k 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 ...
3
votes
1answer
7k views

Automatically “Allow Access” for IMPORTRANGEs in Google Sheets?

I have a set of Google Spreadsheets I want to reproduce (not share) for several users. These users are not going to be able to figure out how to Allow Access (for example, some of the IMPORTRANGEs are ...
-1
votes
1answer
2k views

How to reference a cell in a different file [duplicate]

I have two separate Google Sheets files ("File A" and "File B") that are in two different places in my Google drive. Is it possible for me to reference a range of cells in "File A" to be copied ...
3
votes
2answers
9k views

How can I merge two columns by using QUERY?

I have a master spreadsheet that contains columns like so: FirstName LastName Gender etc, etc, etc I need to import from that master sheet into another sheet that filters by one of the other ...
2
votes
1answer
753 views

Is there anyway to call an IMPORTRANGE() and have it include all sheets?

Here is my current function that combines the current data with the first archive. I'd like to set it up as a failsafe for the future so when there's a new archive it will be included in the import: ...
4
votes
1answer
5k views

Unable to parse query string for function Query, when using IMPORTRANGE

This is the problem I'm seeing: Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND The formula is of the form: =query(importange("...", "Sheet!A:V"), "select D where ...
3
votes
1answer
131 views

Import only those cells from a spreadsheet that have certain conditional formatting

I have created a Google Form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created conditional formatting to highlight the ...
3
votes
1answer
448 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
2
votes
1answer
475 views

Inserting text from a cell into an IMPORTRANGE formula

I have a spreadsheet (Spreadsheet B) with a number of formulas which require data from another spreadsheet (Spreadsheet A). Many of the formulas in Spreadsheet B reference different sheets (on ...
3
votes
1answer
394 views

Reverse lookup from Google Spreadsheets key

I can't figure out where the data in an IMPORTRANGE function is coming from. How can I use the spreadsheet key to find the the original spreadsheet IMPORTRANGE is pulling from?
0
votes
1answer
594 views

Query formula limitations Google Sheets?

I'm trying to run a query (IMPORTRANGE) formula in a new Google sheet. The data I'm trying to load is from another sheet. The source sheet contains 6,000 rows and 12 columns. I tried: =QUERY(...
1
vote
2answers
1k views

Row by row comparison with FILTER returning error

I am trying do a row by row comparison of two separate sheets, and display the unequal rows on a third sheet. As an example, rows three and five on Sheet1 are different from Sheet2 and I want to ...
3
votes
1answer
179 views

IMPORTRANGE as dependent function

I am trying to write a script which sets the function IMPORTRANGE in a specific cell, using as KEY the content of another cell. I have the list of the KEYs in Sheet2 and here is what I have so far: ...
0
votes
0answers
637 views

Which of the functions INDIRECT or IMPORTRANGE slows down my Google sheet the most?

I have a master Google sheet that: Uses the importrange function to fetch data from eight different columns in 8,191 separate Google Sheets (files, not only sheets/tabs). To be extra clear: in this ...
4
votes
2answers
4k views

How to use INDIRECT inside an IMPORTRANGE function?

I need help to dynamically fetch a value from another Google spreadsheet like this: FILE1 has 0 or 1 values in column G. Now I want to fetch the G column value from FILE1 with a row number specified ...
-1
votes
1answer
349 views

Replace sheet name with gid number in Google Sheets

I want to replace the sheet name with gid number in Google Sheets. =importrange("1anqeokmYsrtsdssdsx9QHOXqoVkgio254O8","Sheet1!K5:M5") How can I replace the Sheet1! with its gid number?