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
0
votes
1answer
31 views

importrange & query

I don't have programming background, but as a novice, experiment with formulas on my own. I have two separate live sheets; On the 1st sheet (sheet A) tab F, when I write Y into any cell in Column O, ...
1
vote
1answer
10 views

Attempting to use a LOOKUP with an Importrange tab on Google Sheets to make sure values across two sheets are correct, but I keep getting errors

This is the sheet I am working on. The trouble starts on the tab titled "Sectors and subsectors", on row 56 under the column named "checksum". What I am attempting to do is as ...
0
votes
0answers
17 views

How can I get other sheet data with cell function when if I don't know sheet name [duplicate]

I want to view other spreadsheets data with cell function in Google spreadsheet IMPORTRANGE cell function is awesome but, it required to know sheet name so question is how can I get other sheet data ...
3
votes
1answer
53 views

How do I reference a cell for the sheet name in IMPORTRANGE function in Google Sheets when the sheet is in another workbook?

I have two workbooks with several sheets in each. I have a dropdown to select the sheet name that I'm using for reference for URLs and to reference other sheets in the main book. I successfully used ...
0
votes
1answer
32 views

If colE contains value then import colAY from same sheet

I am trying to import 2 columns from one sheet into another but trying to make sure I import only the cells from col2 when col1 has a value (all different values). I imported my first column needed (...
0
votes
1answer
21 views

ERROR IN QUERY FORMULA GOOGLE SHEETS

I need to join two worksheets from different files in another one that already exist in Google Sheets I tried to do this: =QUERY({IMPORTRANGE("1GoKFiJjBKcGQGGi6JMvk9xD5TIypsNSmpLCTeadWQnU",&...
1
vote
1answer
29 views

G Sheet - Sumifs for data from another sheet

I have a sheet with bank statements and a want to set up a summary sheet with the total amounts per client. I know how to do that from within the statements sheet, e.g. summing up client A: =SUMIF(B1:...
0
votes
1answer
49 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 ...
0
votes
1answer
41 views

How to use an expression or formula on values from IMPORTRANGE

I am trying to use an expression on the values that are imported from another spreadsheet. The IMPORTRANGE copies the raw data, and with QUERY I can then specify which columns to use, so I can skip ...
1
vote
1answer
25 views

importing from multiple workbooks for Google Sheets to ignore workbooks that have nothing listed, instead of returning an error

={FILTER(IMPORTRANGE("116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk", "Trade and Manufacture!P17:T"), IMPORTRANGE("116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk", "...
0
votes
0answers
20 views

How to combine importrange condition with ifcondition?

I would like to ask, how to use IF condition in IMPORTRANGE condition. I want to connect sheets like : In Sheet 1, I want to apply "condidtion IF" for example: IF(A2:A10="black";...
0
votes
1answer
58 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'!...
2
votes
1answer
20 views

Import specific rows and formulas from master sheet

I have been looking for hours now how to solve my problem, as it follows : I want to duplicate this master sheet a hundred times and be able to let the end-users fill in the green cells, without ...
0
votes
0answers
12 views

Is there a way to import data from an added cell into a single cell?

I'm in charge of keeping track of Teacher/Student communication. Each student has their own data sheet where the teachers can update with new dates as they talk to students. Is there a way to pull the ...
-1
votes
1answer
39 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 ...
0
votes
0answers
24 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, ...
1
vote
0answers
50 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
47 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
26 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
151 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
371 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
801 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
1k 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
34 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
50 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
95 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
42 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
305 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
18 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
91 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
32 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
16 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
702 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
122 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(...
-1
votes
1answer
44 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
40 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
76 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 ...
3
votes
1answer
441 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
139 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
30 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
203 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
71 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
159 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
78 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
889 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
501 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
110 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
35 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
3k 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
54 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(...