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.

46 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
2k 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 ...
que syrah sarah's user avatar
2 votes
1 answer
264 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 ...
Wences's user avatar
  • 21
1 vote
1 answer
31 views

How to sum data on one row from multiple selected Google Sheets

I am tracking paid advertising key performing metrics on both Google & Facebook ads platforms on two separate Google Sheets, however, I'd like to combine both datas collected into one master sheet....
alphex111's user avatar
1 vote
1 answer
570 views

How to create Google sheets range off of 2 separate columns

I need to create a range off of two separate columns within a sheet. Let's say column A is my index, while column D is third party index. When using VLOOKUP i can lookup my index to find 3rd party ...
Kuba Stachu's user avatar
1 vote
2 answers
452 views

Updating IMPORTRANGE based on date

I have a spreadsheet I have created with multiple tabs for users to input data on Wednesday of each week. I have a cover worksheet with an IMPORTRANGE formula to pull the data from the users sheets so ...
Dylan's user avatar
  • 11
1 vote
0 answers
38 views

How do I filter in IMPORTRANGE using SEQUENCE and ARRAYFORMULA?

I am having issues with including a FILTER option in my current working formula listed below: =QUERY (IMPORTRANGE("1n7qMGR9p8xD-8tyPIhfrcyBEsW8FAUMJMHmgxM7xIVI","Consultant Directory!A6:...
MarvelousMar's user avatar
1 vote
0 answers
30 views

Add more conditions to the formula

=query({IMPORTRANGE("1c6ihzJjzD_Nhbz5rB1s0485PS98V-Q4bfVAiIon5vSA","MC2!A11:S5000")}, "select Col19, Col1, Col2, Col3, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, ...
Anastasia's user avatar
1 vote
0 answers
139 views

Get the url-sheet from an other cell in Importrange

I am looking for a way to change the url in an importrange without actually opening the formula, but just changing the url in an other cell. I tried with putting the cell reference, with the hyperlink ...
Anaelle's user avatar
  • 11
1 vote
1 answer
327 views

Google sheets import columns based on date value

Google sheets for simplicity's sake say I have two tabs, one with master data and one that is a search function to display a certain part of the master data. The issue is I only want import certain ...
Eyetee's user avatar
  • 11
1 vote
1 answer
26 views

How to combine/Link values of Spreadsheet A onto B while preserving data added on B Sheets against data coming from A?

There are two spreadsheets that are used by two teams, Team A and Team B. Team A provides directions and posts work orders to Team B. Team B in turn enters comments on the actions completed. Each team ...
Shiva's user avatar
  • 111
1 vote
2 answers
975 views

Appending / Adding manual data input to end of IMPORTRANGE dataset

I am trying to figure out how to append / enter manual data to the end of an IMPORTRANGE list. In my spreadsheet, each tab is a month. I want to IMPORT the prior month's list (rows) and then be able ...
tami's user avatar
  • 21
1 vote
2 answers
167 views

Formula parse error on importrange query

I'm trying to recreate what's happening in this video at 7:17 https://youtu.be/5S7laJS9meU?t=437 I want to merge two sheets and remove the empty rows. =QUERY({IMPORTRANGE(L2 ,"sheet1!A2:F20")...
Mathias Grotrian's user avatar
1 vote
0 answers
116 views

How to automatically modify (fill down) separate IMPORTRANGE formulas for each consecutive individual cell in a column, instead of the entire range

Is it possible to automatically modify (or fill down) separate IMPORTRANGE formulas for each consecutive individual cell in a column, instead of the entire range? Example of three consecutive formulas ...
joey's user avatar
  • 11
1 vote
1 answer
536 views

Query, Import Range and Concat

I'm wanting to import whole rows of data from 'SPREADSHEET A' to 'SPREADSHEET B' but only if Column 11 in 'SPREADSHEET A' contains the text 'EXPIRED'. The data in 'SPREADSHEET A' contains about 12 ...
April's user avatar
  • 11
1 vote
1 answer
3k views

Remove blanks in import range of multiple arrays

I have an importrange formula as below which references multiple ranges, calling the sheet URL's using the 'L Links'!Bx, reference, each 'book' having an identical sheet set. (There are actually 90 ...
Castleman's user avatar
1 vote
1 answer
492 views

How to filter out empty cells in Google Sheets with Query & Importrange

I am trying to use this formula but it's not working. Do you hava an idea why? QUERY(IMPORTRANGE("IMPORTEDDATASHEET";"06_20!M:AJ");"SELECT SUM(Col17) WHERE Col1 = 'Company ...
N.K.'s user avatar
  • 11
1 vote
0 answers
334 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 ...
Chris's user avatar
  • 11
1 vote
0 answers
555 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(...
Sean Ritchie's user avatar
1 vote
1 answer
124 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 ...
Keanson Ye's user avatar
1 vote
1 answer
57 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-...
user avatar
0 votes
1 answer
33 views

IMPORTRANGE sum column with condition

=SUM(IMPORTRANGE("1kWMBhk0T423p411K5_5sKOMQFdAsEDapdasYyr9gZj8","Oct!N2:N") "SELECT Col16, where Col16 contains 'Paid' )") I need to calculate only the total of paid ...
user321359's user avatar
0 votes
0 answers
238 views

Importrange changes the format only for a couple cells

I am using importrange and for some cells google sheets changes the format of only a couple cells. I have attached a screenshot. The original worksheet has the correct dates M/DD/YYYY. So I am ...
Nicky's user avatar
  • 1
0 votes
0 answers
251 views

Using Query & Import Range function to import data range with a date filter

I have been able to use the the Query and Import Range function perfectly. =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/13eoPsqGik4ZWFGPURrC9RYdlOuxdbCbQWXzWA9LC1L4/edit#gid=0",...
Jaelyn Brown's user avatar
0 votes
0 answers
110 views

IMPORTRANGE contains specific columns with multiple answers

Example, one person can enter 5 events with several options for participating (both days or Sunday only or 1st go....) how do I get master1 sheet to only show contestants on Saturday and master2 only ...
RoxAnn Moeller's user avatar
0 votes
0 answers
131 views

IMPORT RANGE PARSE ERROR

I have this arrayformula where I need to match cells in a column from one worksheet to another and I used Importrange to link these two but it's giving me errors and I'm not sure what i'm missing here ...
Timo's user avatar
  • 1
0 votes
0 answers
161 views

Gsheets Query Importrange not giving expected results

I'm having an issue with the Query(Importrange) function of Google Sheets. I'm using the following formula =Query(IMPORTRANGE('Importrangelink,"'Sheetname'!X1:AA130"),"select Col1,Col2,...
Laur's user avatar
  • 1
0 votes
0 answers
35 views

Copying a Google sheet into new sheets while maintaining the original Importrange data

I have 3 different master sheets: (1) Hours (2) Hours & Wages (3) Master labor: $ sheet Each sheet is connected. For example: The hours are entered on sheet (1). Sheet (2) has the wages, ...
Joe Frazier's user avatar
0 votes
1 answer
2k 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("...
Katherine Withrow-Mielo's user avatar
0 votes
2 answers
346 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 ...
NLT821's user avatar
  • 1
0 votes
0 answers
441 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 ...
Riccardo's user avatar
  • 579
0 votes
1 answer
1k views

Dynamically reference DATA in Query in Google Sheets

I have a query in a Google Sheet structured like so: =QUERY({IMPORTRANGE(Expenses_2018Q4,"DATA_Expenses"); IMPORTRANGE(Expenses_2019Q1,"DATA_Expenses");IMPORTRANGE(Expenses_2019Q2,"DATA_Expenses")},"...
Rob Welan's user avatar
  • 101
0 votes
1 answer
2k 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-...
Jenna Fortunato's user avatar
0 votes
2 answers
2k views

Import Range of cells as per today date in another sheet

There are three columns A, B, C AND today date is in the first row of the column A means A1. I need to import these three columns date excluding date row. A2:A100, B2:B100, C2:C100 in another sheet. ...
Mahantesh Ambole's user avatar
0 votes
1 answer
299 views

How to modify Query Options no_format to allow some format, but not others?

I have to replicate a Google Sheet, and am using ImportRange and Query together. I need Query also because the first sheet has urls under them, which I cannot have on the copied sheet. I was able to ...
Wes's user avatar
  • 1
0 votes
3 answers
2k views

Importrange with multiple criteria

Looking to countifs data from another workbook with multiple criteria. So far I have =COUNTIFS(IMPORTRANGE("URL", "Data save!$A$2:$A$5011"),">=01/04/2022") This ...
Stuart Bell's user avatar
-1 votes
1 answer
91 views

Import a working formula from a different Google Sheet

I want to import a working formula from doc 1 to doc 2. I used importrange but then it importet the data from doc 1 to doc 2 and not the formula. I then used a second spreadsheet in doc 1 to show the ...
itenmn's user avatar
  • 1
-1 votes
1 answer
396 views

Can I convert an entire sheet into all caps when data is imported using IMPORTRANGE?

I am using a form to collect data from customers. After submitting the form and collecting the data in Form Responses 1 (name of Google Sheet), I've created another sheet which imports most data, not ...
Rod Storm's user avatar
-1 votes
1 answer
835 views

IMPORTRANGE query with checkbox

I'm trying to do an IMPORTRANGE with query with checkbox. However I keep encountering parse error. =QUERY(IMPORTRANGE("1pzzOzjtJ8GJOWnkBozdO0anKHnbeREvadEc4rzY4ezI",'Guest Speaker Tracking'!...
Yuki's user avatar
  • 1
-1 votes
1 answer
942 views

Using "IF" or "Query" statement paired with "ImportRange" to bring in data set from one sheet to another

I have a sheet where I input my jobs booked. I want to be able to import information for the first 4 columns (Job Number, Job Name, Salesman, Date booked) if Column F (Permit Required) has a "Yes" in ...
Ryan Hinds's user avatar
-1 votes
1 answer
3k 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 ...
Lulu's user avatar
  • 1
-1 votes
2 answers
4k 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 ...
user217712's user avatar
-1 votes
1 answer
70 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 ...
Ben's user avatar
  • 7
-1 votes
1 answer
95 views

Update values on a second spreadsheet and automatically link and update values in the first spreadsheet

I have two spreadsheets: Spreadsheet 1, the initial data is entered manually. I do an IMPORTRANGE into Spreadsheet 2 with order by Col2. This is what I get when I perform IMPORTRANGE (sort on ID): ...
user61288's user avatar
-1 votes
1 answer
404 views

Force `importrange()' 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 ...
sam's user avatar
  • 6,849
-1 votes
3 answers
840 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 ...
Juan Gracia's user avatar
-1 votes
2 answers
4k 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 ...
Jennifer Dedrick's user avatar