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
0 answers
8 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 ...
user avatar
0 votes
0 answers
22 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 ...
user avatar
  • 1
0 votes
1 answer
23 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 ...
user avatar
  • 1
0 votes
0 answers
18 views

How to approach this? Which formula should I use?

I am working on a Google Sheet in which I am classifying a "product" with an id number and I want to pull out data from another sheet that contains 2 things: confirmation of the id type of ...
user avatar
0 votes
1 answer
35 views

IMPORTRANGE keeps broken

I have several raw data files which I have linked with importrange to another files. For some reason my files where getting broken since I keep getting importrange internal error. Also, they take too ...
user avatar
  • 1
0 votes
3 answers
67 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 ...
user avatar
0 votes
0 answers
16 views

Fill handle not working when importing from another workbook

I can get the data from 1 sheet to another, but when I try and use the fill handle to complete the column it only copies the formula and does not complete the series. How can I get the handle to ...
user avatar
  • 1
0 votes
1 answer
61 views

IMPORTRANGE with condition

I Would need help with this one. I would like to transfer data from one Google workbook to another using importrange but with a condition. Condition: If column 2 is Apple (transfer data from column 3) ...
user avatar
  • 1
0 votes
1 answer
25 views

How do I get importrange and jointext to combine 3 name cells into 1 cell on a new worksheet in Google sheets?

On Wksht A I have cells C5=last name (i.e. Doe), D5=first name (i.e. Jane), E5=first name (i.e. John). This is to cover 2 joint owners (i.e. husband and wife) in our housing complex. I want to import ...
user avatar
  • 3
-2 votes
1 answer
36 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 ...
user avatar
  • 1
0 votes
1 answer
136 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 ...
user avatar
0 votes
1 answer
45 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 ...
user avatar
  • 1
0 votes
0 answers
119 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 ...
user avatar
  • 1
0 votes
0 answers
15 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 ...
user avatar
  • 1
0 votes
1 answer
260 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 ...
user avatar
0 votes
1 answer
21 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 ...
user avatar
  • 101
0 votes
1 answer
32 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://...
user avatar
  • 105
0 votes
1 answer
188 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"),...
user avatar
  • 1
0 votes
1 answer
27 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 ...
user avatar
0 votes
1 answer
17 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 ...
user avatar
-1 votes
1 answer
54 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 ...
user avatar
0 votes
1 answer
65 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 ...
user avatar
  • 1
0 votes
2 answers
304 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 ...
user avatar
  • 1
1 vote
1 answer
53 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&...
user avatar
0 votes
0 answers
56 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,...
user avatar
  • 1
0 votes
1 answer
31 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 ...
user avatar
0 votes
2 answers
95 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")...
user avatar
2 votes
2 answers
231 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 ...
user avatar
0 votes
1 answer
100 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","'...
user avatar
1 vote
2 answers
338 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"); "...
user avatar
0 votes
1 answer
61 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”);...
user avatar
1 vote
0 answers
57 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 ...
user avatar
  • 11
1 vote
1 answer
41 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 =...
user avatar
  • 11
0 votes
1 answer
253 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 ...
user avatar
  • 1
0 votes
1 answer
75 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, ...
user avatar
1 vote
1 answer
511 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 ...
user avatar
0 votes
0 answers
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 ...
user avatar
  • 13
3 votes
1 answer
953 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 ...
user avatar
0 votes
1 answer
56 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 (...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
636 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",&...
user avatar
1 vote
1 answer
325 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:...
user avatar
  • 13
0 votes
1 answer
388 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 ...
user avatar
  • 1
0 votes
1 answer
99 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 ...
user avatar
1 vote
1 answer
324 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", "...
user avatar
-1 votes
1 answer
424 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'!...
user avatar
  • 1
2 votes
1 answer
29 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 ...
user avatar
  • 21
-1 votes
1 answer
605 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 ...
user avatar
0 votes
0 answers
33 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, ...
user avatar
1 vote
0 answers
252 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 ...
user avatar
  • 11

1
2 3 4 5