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.

Filter by
Sorted by
Tagged with
1
vote
0answers
17 views

Importrange, editing from the sheet that its imported too

I currently use importrange to get timesheets to a master sheet. I then download this sheet every week and update to my KPI's As all the information is on the master sheet where all data is ...
1
vote
1answer
41 views

Help Sorting Data

I have a spreadsheet that I'm using to keep track of stats for players in a league. This is the link: https://docs.google.com/spreadsheets/d/193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk/edit#gid=...
0
votes
1answer
22 views

Query + importrange not providing the answer i need

I am attempting to get some information from a Google sheet Basically if my website Id was to be lets say 14, I'd want to get the name in the row next to it; I am using the function below; =QUERY(...
0
votes
1answer
87 views

IMPORTRANGE QUERY formula filtered by dates range and values from cell

=COUNTA(IFERROR(QUERY(IMPORTRANGE("Sheet1","QC sheet!A792:B10000"), "Select Col2, Col4 where Col2 contains '"&B$1&"' and Col4 contains '"&C1&"' and date "&TEXT(G1,"'YYY-MM-DD'")&...
0
votes
1answer
33 views

Google Query max number of IMPORTRANGE inputs

I'm kind of making a database using the google sheets query function, and i'd like to know is there a max amount of IMPORTRANGE I can do in a query or is there a max amount of cells that the ...
0
votes
1answer
89 views

How do I import data from one Google spreadsheet to another

I need to import a range of data from one Google spreadsheet to another but I keep getting the error: "Cannot find range or sheet for imported range using this formula" =IMPORTRANGE("https://docs....
0
votes
1answer
90 views

How to use external data range for a Google sheet pivot?

I'd like to use another spreadsheet's data as the data range for a pivot table. In order to import data from another spreadsheet, one can use the impotrange function. But can it be imported directly ...
0
votes
1answer
27 views

Update two Google documents at the same time

I have a copy of a Google sheet (single sheet) that I want populated everytime someone edits the original. Is this possible?
0
votes
1answer
32 views

I want to bring in already filtered data into a new spreadsheet

Is it possible to reference filtered data from one sheet to another in Google Sheets? I use the filter button to sort in a master sheet. I then use this formula in a new sheet: =IMPORTRANGE("...
0
votes
1answer
36 views

Move existing SUM downward when IMPORTRANGE expands

I'm building a complex Google Sheets document and for one sheet I use the function IMPORTRANGE. It's very handy and imports new rows from another sheet when they are added. The problem is this: After ...
0
votes
1answer
27 views

Can I retrieve the names of sheets in a public document?

I am currently using the function IMPORTRANGE in a Google spreadsheet to pull information from a public document using the URL. I have to supply a range_string in the format "Sheet Name!A1:D21" to ...
0
votes
1answer
68 views

Add row instead of overwriting cells with IMPORTRANGE?

I'm using Google Sheets to automate my flow of creating Quotations and Invoices for my clients. What I am trying to achieve is: I key in the values Name, Dimensions, Description, Amount, and Price ...
1
vote
0answers
17 views

Adding new rows when using IMPORTRANGE [duplicate]

I have a spreadsheet as follows: A B C D E F 1 steve 12 xxy yellow 12 a1 2 david 32 yyx green 165 b1 3 tom ...
0
votes
0answers
36 views

Importing a Google Sheets range based on checkbox value

I want to IMPORTRANGE of all columns B2:C if the respective A column is TRUE (a checked checkbox). How can I do this?
0
votes
1answer
22 views

How to import cell data from one workbook to a different workbook?

All answers I have reviewed say use IMPORTRANGE by referencing the "KEY=" in the URL of the source cell. I find no "KEY=" in the source URL. So I always receive a "parse error."
0
votes
0answers
15 views

New solution to identify BY as a column label instead of an identifier?

I'm new to this, so I've posted this question as an "answer" to this post QUERY error for BY column a previous solution for this issue no longer works, and I need a new way to tell google (via code) ...
-1
votes
1answer
209 views

UNIQUE ,INDEX AND IMPORTRANGE

I am stuck. I use the import range to get a set of data however now I need to the unique values that that matches the import range that I have. Say for example below is randome sample. I have import ...
1
vote
0answers
51 views

Query Import Range returns two rows

I've been using =Query(Importrange( functions for quite a while now and something I can't figure out is why the import is returning with two rows. Here's the formula I've been using: =QUERY(...
0
votes
0answers
41 views

Loading Data Error Query with Importrange Gsheet

I am trying to use QUERY with importrange function to fetch custom data from another spreadsheet, it worked for a while but now it through loading data error consistently. if I refresh the sheet it ...
0
votes
0answers
17 views

Google Sheets: updating cells that has been fetched by IMPORTRANGE() [duplicate]

I've got two Google Spreadsheets. Spreadsheet B fetches data from Spreadsheet A using IMPORTRANGE: =IMPORTRANGE("url", "tab!A1:JB19") What I want to achieve is to be able to write over fetched data ...
-1
votes
1answer
35 views

How many 'importranges' are being used in a selected Google Sheet

How to find out how many importranges are being used in a single Google Sheet?
1
vote
1answer
35 views

“Calculating formulas” in Google Sheet disaster

I have a worksheet with 13 sheets. the largest one has 2000 rows. I have already deleted all the possible blank rows i could. I have also read all the guides on how to make a Google Sheet faster and ...
0
votes
0answers
21 views

How do I edit cells in Google Sheets, after filtering or importing a range [duplicate]

when I import a range, in Google Sheets, or I use the formula Filter(), I get an array of data. I would want to then be able to edit the imported/filtered data, is that doable? of course, without ...
0
votes
0answers
28 views

Linked Google Sheet requires authorization although public

I have made a Google Sheet that links to another Google Sheet, using IMPORTRANGE(). Although the linked sheet has Public accessibility, I am still required to authorize access to the linked sheet. Why ...
2
votes
1answer
212 views

Dynamically reference data from multiple tabs and sort it

I've got a spreadsheet with multiple tabs of data. The data contains 2 columns, A = Categories, B = Quantity. I've created a copy of the spreadsheet HERE (please use file > copy) if you would like ...
3
votes
1answer
85 views

Importing a row from one Google Sheet to another

Doc1: I have individual sheets setup for each Game Week which list the football matches being played on that particular week. Doc2: I have an individual sheet setup for each team. I'm looking to pull ...
0
votes
1answer
26 views

Pushing data from one sheet to another based on a condition, without making sheets dependant on one another

Trying to see if something like this is possible within Google Sheets. I have 2 test sheets that are linked with query(importrange(... And I can have Sheet2 updated automatically when a row in sheet ...
0
votes
3answers
126 views

How to use Importrange in a Query and filter by dates

I am trying to IMPORTRANGE if the condition in column1 that is text formated ( Column1 = September 4, 2019 alas 5:10 pm ) contains the word September. I am using the following formula. The other ...
0
votes
1answer
63 views

How to combine 3 sheets into one using QUERY(IMPORTRANGE)?

I am trying to combine 3 different sheets of data from range A2:O Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 using Query({IMPORTRANGE(... function. I tried using the formula below ...
1
vote
2answers
97 views

I am having trouble using indirect to access a cell in a different Google Spreadsheet

I have 2 spreadsheets, Test1 and Test2. In Test2, Cell B2 I want to access a cell in test1. I want to use the value in cell A1 (the value is test1) indirectly to access cell A2 in test1. This is the ...
0
votes
1answer
29 views

Concatenation within IMPORTRANGE

I'm completely stuck on this one -- I need to use IMPORTRANGE function but want to make the sheet it pulls from flexible via concatenation -- here is my formula with a scrubbed URL: =importrange("...
1
vote
1answer
490 views

Create table showing difference between values in two pivot tables

Our bookstore has two separate documents in Google Sheets (one containing purchase data and one with sales data). Each document contains a sheet with a pivot table that sums up total purchases/sales ...
-1
votes
1answer
237 views

How to merge data from multiple Google Sheets with formula?

I have 10 columns in 10 Google sheets and in all sheets are the data labeled like Month | Total number of winter/summer schools attended | Sr. No. | Title | Date | Venue | Organisation | Number of ...
2
votes
1answer
64 views

Google Sheets Import Range Query Error

I'm trying to create a sheet that only shows me LOT Codes of specific products from a different workbook that has all of our products and LOT Codes. From what I've seen the Query with Import Range ...
0
votes
1answer
32 views

Pull data from another apreadsheet where Row and Column are strings

I am trying to pull data from a different sheet in google sheets by matching row and column header EG SheetB LOC prox dist qty sjc 12 15 19 dfw 10 16 8 atl ord In ...
1
vote
2answers
2k views

Combining IMPORTRANGE, SUMIFS, QUERY with cells that contain numbers and text

I'm having an issue combining SUMIFS with ImportRange in Google Sheets. I found answers suggesting to nest it with QUERY. However, the issue is that one of my criteria is non-numerical. Formula in ...
1
vote
1answer
46 views

Simplify multiple OR statements in a QUERY using IMPORTRANGE

I am trying to query values from a different sheet using a range from the current sheet. Is there a way to simplify the formula and get rid of all the ORs? Like maybe using a FOR loop? =QUERY(...
1
vote
1answer
225 views

How to reference a local cell in QUERY?

I just about have formula 100% perfect. Just one issue: Formula (Works): =QUERY( ImportRange( "https://docs.google.com/spreadsheets/d/1Lf4r_b0fmFh6fClZsGmfZmo8ZD87qf8N_0f-Jaoyu-g/edit#gid=0", "...
0
votes
1answer
21 views

How to check separate sheet cell for any data, and return a Y?

I'm using several Google sheets to capture product data and optimize it. One sheet will feed data into the next, and then again into another sheet, using this formula: =IMPORTRANGE("https://url-to-...
0
votes
1answer
118 views

How to combine these funcions (FILTER + IMPORTRANGE) in one? [duplicate]

I have all data in one sheet and I need to filter the imported data to another sheet. How can I do that in one function? Function to filter data which I use: =FILTER(A7:C,RIGHT(A7:A,7)="?id=999") ...
2
votes
1answer
43 views

How to aggregate data from multiple Google sheets with a tag

I am importing data (using IMPORTRANGE) from 3 different sheets to 3 different tabs of a google sheet. Then I am aggregating those three sheets into one and also filter them using a query. Ex: =...
1
vote
2answers
488 views

Importrange when copied to other cells automatically change range

I am using importrange to pull data from my responses page to my spreadsheet. I have completed the first sheet but I now need to go into the sheet to follow on where sheet one has run out of space. ...
0
votes
1answer
93 views

Importrange (or maybe another part of formula) behaves differently after a short time period

I am using this formula to look for data in column F related to data in column A between two spreadsheets. =ARRAYFORMULA(IFERROR(VLOOKUP(A2:A; {IMPORTRANGE("spreadsheetID";"sheet1!A4:A")\ IMPORTRANGE(...
1
vote
1answer
35 views

Dynamic Master sheet that grabs red formatted cells from another sheet

The title may be a little too ambiguous but I'll try to give a rundown as best I can; I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it. The Main tab is blank ...
1
vote
1answer
84 views

IMPORTRANGE from a separate sheet based on closest date to today's date

Sheet1 will have data with different past dates Sheet2 - I want to import data from the 1st sheet and find the closest date to today's date. https://docs.google.com/spreadsheets/d/...
0
votes
1answer
22 views

Importing only certain rows after looking at other answered questions

=QUERY(IMPORTRANGE("URL","SHEET1!A5:P85"),"SELECT * WHERE K:K contains 'Name.s'") Error Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "K "" at line 1, ...
0
votes
2answers
334 views

IMPORTRANGE connect sheets

When using IMPORTRANGE on Google Sheets, one has to "connect sheets" as follows: Where can I check which sheets are connected, and what exactly (what access rights etc.) this "connection" implies?
0
votes
0answers
137 views

ARRAYFORMULA + QUERY + IMPORTRANGE - Final cell reference in IMPORTRANGE is acting like it's absolute when I need it to be relative

I know I'm chaining a lot together here, but it's SO close to functional. Here is my formula with the doc address altered for privacy. =ARRAYFORMULA(IF(ISBLANK($AE$3:$AE),(query(importrange("https://...
1
vote
1answer
202 views

Google Sheets Formula Import Range with Indirect

I have this formula and want the reference to Archery to reference Archery which will be in Cell E1. I tried using the indirect formula but can't get it to work with the formatting for Google Sheets. ...
0
votes
2answers
1k 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 ...