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
1answer
22 views

How to use use cell references in the WHERE part of a QUERY / IMPORTRANGE formula

Can you tell me what's wrong with my formula? = QUERY (IMPORTRANGE ("url googlesheets database"; "Data range"); "SELECT Col1 WHERE Col1 =" A3 "AND Col2 =" B3 "") The "A3" and "B3&...
0
votes
0answers
30 views

Import data from a different file but only if it matches some of the data in the new one?

I would like to copy information entered from another Google Sheets file but only if it relates to the information in the new file. For example, MR SMITH's employee number is entered into one sheet ...
0
votes
0answers
23 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,...
0
votes
0answers
4 views

how to importrange with strikethrough and bold [duplicate]

I have data in Sheet1 that I wish to import into Sheet2 with ImportRange. However, when the cell in Sheet1 is marked with a "strikeout" I want it to also import as a strike-out cell in ...
0
votes
0answers
17 views

Creating a sheet that pulls columns from other tabs

I have created a Google Sheet with multiple tabs for individual project schedules. The individual schedules have two columns: one with the tasks, a second with the project's name and the due dates. I ...
0
votes
0answers
13 views

Import range with a sum built in

I have two questions: What formula would I use to importrange from another spreadsheet if I wanted it to import as a sum of two columns from another sheet? The second question is: in this other sheet ...
0
votes
2answers
36 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")...
2
votes
2answers
112 views

Can a Script distinguish IMPORTRANGE N/As due to non-existent Tabs from N/As due to not having access permissions?

I'm creating a sheet that will import and process data from other Sheets. On a daily basis, the user will be given a new document to process with it. I have cell B1 reserved for them to enter the URL ...
0
votes
1answer
25 views

How to refer to a cell value within importrange function?

I am using this formula to bring data from another spreadsheet file based on name of the month. This time for February.. =query(importrange("1L86iP0GLHTubwfvxs1kJ4ocbmgRAd4Iz0000000M","'...
1
vote
2answers
44 views

How to get value from cell with query and importrange functions in Google Sheets?

A1 cell has 1. And I try use value from this cell through: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/xxxxxxxx/edit?usp=sharing"; "Sheet1!A:P"); "...
0
votes
1answer
43 views

Query + Importrange functions together

I'm trying to get range from different sheet IDs. But getting error message. =query({IMPORTRANGE($X$5,”CASES LIST!B9:T58”);IMPORTRANGE($X$6,”CASES LIST!B9:T58”);IMPORTRANGE($X$7,”CASES LIST!B9:T58”);...
1
vote
0answers
14 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 ...
1
vote
1answer
33 views

How to to get coordinates from addresses coming in from importrange?

I have addresses coming in from importrange and I am using this script to get coordinates. function myFunction() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Geo 4') var range =...
0
votes
1answer
38 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 ...
0
votes
1answer
53 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
115 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
19 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
160 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
34 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
71 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 ...
0
votes
1answer
103 views

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col7

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
140 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
238 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
53 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
115 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
21 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
218 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
22 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 ...
-1
votes
1answer
173 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
25 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
131 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
48 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
291 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
942 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
1k 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
3k 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
44 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
144 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
2answers
158 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
75 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
636 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 ...
0
votes
1answer
34 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."
-1
votes
1answer
1k 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
211 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
55 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
47 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
209 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
807 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
208 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 ...