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
-2
votes
1answer
30 views

i can't find the problem to this formula

=UNIQUE(QUERY({IMPORTRANGE("1xWx1FRfvCfmvYi9Sb7Gh5lIAb-NAt0RG0h-e_HKmxjU","APP Directory!A2:U");IMPORTRANGE("1xWx1FRfvCfmvYi9Sb7Gh5lIAb-NAt0RG0h-e_HKmxjU","APP ...
0
votes
1answer
25 views

Drag IMPORTRANGE formula and auto fill multiple cells

I import multiple cells by a checkbox with this formula: =IF(A1=True;ARRAYFORMULA(IMPORTRANGE("URL";"Sheet1!A1:A10"));"") But I'm looking for a solution to be able to ...
0
votes
1answer
13 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 ...
0
votes
0answers
45 views

Why is my Google Sheets importrange repeatedly throwing internal errors?

Today several Import Range functions in one file started throwing internal errors. I got things working and within a couple hours the same thing happened again. Have I hit some limit, or some ...
0
votes
0answers
12 views

In Google Sheets I'm trying to import data from one sheet to another based on two conditions first is by Name, second is by date

I'm using the formula below but would like to include a second condition: B1 contains the date and A1 contains the name. I have the date part working but I cannot include the Name as a second ...
0
votes
1answer
96 views

google sheet how to import cells based on value in different cells

So I have two sheets. Sheet A tab X contains two columns, first one with an url for a google doc and in the other column text IDs. Sheet B tab Y contains a column with text ID of several more files ...
0
votes
1answer
19 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 ...
0
votes
1answer
31 views

How to show the data from another spreadsheet but only the latest week

I have 2 spreadsheet, the first one consists of all of the data of withdrawal and deposit of items. The second spreadsheet is where the summary of the data shown. Here is the master data link: https://...
0
votes
1answer
76 views

Google Sheets Query with importrange by date range

Trying this Formula: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/18r5cARjmlRsbb0VRaAS6kAMkJm1p2qe0LsPCtYLS1xA/edit?resourcekey#gid=561906440","Form Responses 1!A:X"),...
0
votes
1answer
23 views

importrange on google shhet

I have a question regarding the importrange() function. This is my formula: =ImportRange("1u0TjjekVHHb6shYiSWoo0W1ygxuSu2tVvLstnEE1NFo";"Juillet!I5") I have about 20 rows of data ...
0
votes
1answer
15 views

Need help filtering entire rows from reference sheet to master sheet where column text meets criteria

I feel like this should be a relatively simple issue but everything I write is clearly incorrect or leaves me needing to do work manually every time new data is made. Basically I have a series of ...
-1
votes
1answer
25 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 ...
0
votes
1answer
45 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 ...
0
votes
2answers
131 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 ...
1
vote
1answer
48 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
37 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
49 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
1answer
27 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
2answers
78 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
190 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
52 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
130 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
58 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
32 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
39 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
149 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
60 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
370 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
20 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
548 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
44 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
756 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
309 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
277 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
353 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
86 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
265 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", "...
-1
votes
1answer
329 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
25 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
489 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
30 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
220 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
54 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
487 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
2k 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
5k 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
60 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
631 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
214 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 ...

1
2 3 4 5