We changed our privacy policy. Read more.

Questions tagged [google-sheets-query]

Use for questions about QUERY built-in function from Google Sheets.

Filter by
Sorted by
Tagged with
0
votes
1answer
17 views

G Sheets - Can't seem to make not contains and is not null work together

I want to return results for col A & B where B is not blank and where F doesn't contain any city in California so, ', CA'. I can get each operator to work separately, =QUERY('805'!A1:F1105, "...
0
votes
1answer
19 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
0answers
16 views

Google Sheets Query - Timestamp [closed]

I will be adding a link to my google sheet at the end of the post. I need to query the data into separate sheets based on the month. I have spent many hours trying to figure this out, any help will be ...
0
votes
0answers
9 views

Totals on query table

I would like to get totals on the bottom of a table created with a query function. I have managed to total one column but when I try and get a total for the next column it displays the total 1 cell ...
0
votes
1answer
17 views

Filter Google Sheet based on multiple checkboxes

I have a Google Sheet with multiple columns filled with checkboxes with each row being for a specific product, above each column is another checkbox and the idea is to use these top checkboxes to ...
-1
votes
1answer
58 views

Inventory Management where main list highlights items checked out/ in

I am working on an inventory management list where barcodes are scanned out and scanned back in. My sheet is attached to forms. I have set the item sku# on the main inventory list to highlight red ...
0
votes
2answers
44 views

How to filter or query only selected columns based on a dropdown

I have a sheet with data, theres a section laid out 8x9 with a layout approximately similar to below (didn't recreate all 9 rows): Red Orange Yellow Green Blue Indigo Violet Grey X - X - - - - - X ...
0
votes
1answer
21 views

ORDER BY generating error in Google Sheets' QUERY

I'm getting a '#Value!' error when I try to sort data returned by a QUERY statement. This is the basic statement: =query('Raw Data'!A:G,"Select A, C, D, sum(G) where B='instagram' and (D='Female ...
0
votes
0answers
12 views

COUNTIFS+importrange

There are two different sheets 1 & 2. Both has columns named "number of files completed". I want to create sheet 3 where it shows number of files completed in both sheet 1 & 2 in a ...
0
votes
1answer
20 views

Sheets query: Losing string values?

How can I get =query to handle a column of mixed numbers and strings? I have a column of accounts names. Some are purely numeric (e.g. 123), and some are alphanumeric ("x456"). A 123 ...
0
votes
1answer
20 views

Google Sheets: one query for Sum and Filter?

If I have a sheet with data like this: A B x 1 y 2 z 3 x 4 I can sum the values with =query(A:B, "select A, sum(B) group by A") How can I then filter this result? For ...
1
vote
1answer
18 views

Google Sheets - How to use results from INDEX formula in a new QUERY function

In Google Sheets I have an =INDEX function which is producing a number of references for data in another worksheet. I need to use those references in a QUERY function. I've not found a good way and ...
0
votes
0answers
19 views

Query Across Several Columsn/Rows of Data

I have tables in a single sheet organized similar to this: I want to write a query that can summarize the values of each line item uniquely. For example, total "Labour" across all 5 ...
0
votes
1answer
37 views

How do i Import a rows from one Google Sheet to another with filter?

I have a Google Form, the answers go to Google Sheets. I want to import answers from sheets (Аnswer) into new sheets but with a filter applied. For example: from sheets (answer) into a new table, I ...
0
votes
1answer
30 views

Search a Column of Data & Enter a Specific Value based on 2 criteria

I have a sheet, where I will enter a bunch of data with skus into 1 column, and have search terms somewhere else. What I want is to automatically, look at the SKU AND the search term, and then bring ...
0
votes
1answer
11 views

Google Sheets - Sum if matching options

I'm creating a cashflow management sheets that can count all my expenses and incomes, also to track the usage of my budgets. I can categorize each expenses by selecting from a list of options. My ...
0
votes
0answers
30 views

Partial match two strings with wildcard operators both ways

I have two lists of property names. Sometimes a name in List A has extra characters; sometimes List B has the extra characters. I want to pull associated data from a column in the tab with List A and ...
0
votes
1answer
28 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://...
1
vote
1answer
19 views

Compare imported range with existing range, and filling corresponded data to the fields

I am not sure how to import data to corresponding cells. query(IMPORTDATA("https://www.iftach.org/taxmatrix/charts/4Q2020.csv"), "Select Col4 where Col1 = '"&A4:A&"'&...
0
votes
1answer
18 views

Needing to change a column to false when Data Validation is changed

I am using Google sheets and have a cell that has data validation and I am putting check boxes (I4:I) for people when items are received, they need to be changed to "False" when the Data ...
0
votes
1answer
13 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 ...
0
votes
1answer
22 views

Google Sheets: Joined queries registering as two arguments in IFERROR() function

I'm joining two queries together using an array: ={query(A1:B,"Select A where B is not null");query(C1:D,"Select C where D is not null")}. I have it wrapped in an iferror() that, ...
0
votes
1answer
45 views

QUERY syntax using cell reference more than 1

I'm trying to use a cell reference instead of static values. =QUERY(Responses!B1:I, "Select * where G = '"&B:B&"'") I use code like this because the data is varchar, but ...
0
votes
1answer
39 views

Using query as a text join

A few days ago I reach the limit of 50000 characters in one cell, I found a solution with "query" but I need a delimiter inside the formula that I haven't been able to find: This is the ...
0
votes
1answer
33 views

Google SpreadSheets query: how to join "grouped by" cells in a list?

Suppose I have this table: | Name | Amount | Category | | name_1 | 10 | A | | name_2 | 2 | B | | name_3 | 3 | B | | name_4 | 6 | C | Thanks to this ...
2
votes
1answer
32 views

Need to sum the number of instances of texts in a column using Query function in Google Sheets

Still a noob in Google Sheets. I am trying to create a sheet with the statistics with the data coming from Sales sheet . I want to sum the quantity of all items sold according to sizes. For ex. How ...
0
votes
1answer
21 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 ...
1
vote
1answer
19 views

If cell in Col A is blank substitute with cell in Col B

I'm attempting to combine two columns from another sheet into one through the QUERY function. My plan is to make it so if a cell in Col A is empty then a cell in Col B will be substituted. However, ...
0
votes
1answer
34 views

Combine data from multiple sheets to create a stacked line chart

I have multiple sheets with three columns each: Date, Invested Amt, and Return Amt. I am trying to merge the values and get a Result dataset to create a single stacked line chart of Invested vs Return ...
1
vote
1answer
34 views

How to stack two columns in Google Sheet with column name in another column?

I have these columns in the Google Sheet. Date A Date B 1/1/2020 3 5/2/2021 328.28 1/2/2020 41 5/3/2021 322.75 1/9/2020 23 5/25/2021 342 1/12/2020 54 5/28/2021 ...
0
votes
1answer
22 views

Cannot get Query to display time

I need help getting to show the result of a dropdown. If you look at C22, there's a dropdown for a specific date. I'm currently working on row 24 and have applied the formulas I think should work. I ...
0
votes
2answers
41 views

How to make variables dynamic in ARRAYFORMULA/QUERY Combination

I'm trying to self populate the first column of the "Main" sheet with a query that returns the first column of the "Finance Office" sheet that matches all three names. I came up ...
0
votes
0answers
35 views

Google Sheets data autofill issue =Query? =Vlookup?

I'm attempting to autofill a budget spreadsheet, based on a paychecks paydate, filling the bills due that pay period. Bills 1-30 Pay Dates ranging from 1-30 I'm hoping to be able to plug in the Pay ...
0
votes
0answers
33 views

What is the Google Sheet query for getting rows excluding non matching rows

The tables will have multiple entries for amount debited and credited details. It also has 5% debit and credit and 1% debit and credit entries as well. Data includes unique flag for districts, Date ...
1
vote
1answer
45 views

What's the formula to select non matching rows by comparing rows in Google Sheets query?

In Google Sheets query, I need to get only non matching debit rows by comparing rows say if amount debited (S1 flag - row 1) matches with amount credited (S1 flag - row 3), it needs to be excluded in ...
0
votes
1answer
19 views

Filtering views based on a cell having a value

I am trying to sort out a spreadsheet which has multiple columns in but don't really know where to start! I am looking to filter the sheet where column C has more than 3 errors for the ID on column B. ...
1
vote
1answer
37 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
1answer
80 views

How to have a query wrapped in an arrayformula auto-populate many rows

I have a query that queries over a set of rows. I want to run this query, itself, for each row in another set of rows. The one value that changes in the query for each row is something in the where ...
1
vote
1answer
30 views

Google Sheets - COUNTIFS with timestamp

I have a column in a table that contains the date and time. This is the form 15.06.2020 09:43:24 17.06.2020 08:21:04 18.06.2020 12:11:34 or also 2021-01-21 11:57:34 2021-01-21 11:58:02 2021-01-21 11:...
1
vote
1answer
20 views

No query result when one of the columns used in the output never has a value

I have a query where the output involves summing two columns. If either of the columns never has a value (given a set of filter criteria in the where clause), there is no result. Why? Here is an ...
0
votes
0answers
23 views

Google Sheets Checkbox Query/Pivot/Other Question

For my pizza hobby I keep track of the pizzas I like to make and the ingredients in them. I have a good sheet with the following data. I would like to make a view of the same data where I can see ...
0
votes
1answer
24 views

How do I chart timeseries data organized by one of the columns?

Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way. three columns: timestamp, email, things_done. I want a chart with time as the X ...
-1
votes
1answer
43 views

how to select and automate "copy by value" to persist data in Google Sheet

I would like to use Google Sheets as a form to query for data, select and store the data I'm interested in. Below what I'd like to try. Please let me know if feasible, and if so, could you tell how to?...
1
vote
3answers
67 views

'contains' and 'starts with' cannot match text with a character after a hyphen

Google Sheets queries cannot match text using contains or starts with when there the text to match contains a hyphen, and the hyphen is not the last character in the text to match. Am I doing ...
3
votes
2answers
126 views

cannot drag query across multiple rows (overwrites data)

Is it possible to click and drag queries? I describe my problem below and also have a reference sheet. cells A1:B5 Category Withdrawal CatA 4 CatB 2 CatA 6 CatB 11 cells C1:C3 Check For CatA ...
0
votes
1answer
47 views

Best way to change dates in Google Sheets in all the tabs?

I have a sheet that is for accountability in my business, I have each month with it's own tab with five week sections and the dates are done by a Monday thru Sunday sections with the date that is ...
0
votes
2answers
40 views

Why doesn't "format A 'yyyy-mm' options no_values" strip the day from the output?

I have some input that contains a set of dates. I want to strip the day from the input and sort by just the month and year. I know there are other ways to do this, but why can't I set the format to ...
1
vote
1answer
71 views

Google Sheets: VLOOKUP formula for a multi line cells range

I have here a sample project, where columns A to C are in FORM RESPONSES TAB/SHEET and columns D and E are in RECORDS TAB/SHEET. In the RECORDS I have a list of names, in alphabetical order, and a ...
0
votes
1answer
16 views

How to find closest similar value above current value, and return a different column on the same row

I'm looking for a way to find the closest similar value(in distance) above the current value(column B), and return the column next to that found value(column C) in column D. A sort of vlookup where it ...
2
votes
1answer
83 views

GOOGLEFINANCE in Google Sheets to get high & low and timestamp of high/low from the day I took trade

I wanted to keep a track of high/low of a trade from the day I took the trade. For a day I am able to get high/low but how to get from the date I took my trade which is stored in one of cell. =IFERROR(...

1
2 3 4 5
16