Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn 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
0 answers
17 views

Google Query function not returning any answers [closed]

I have a datasheet with Dates and individual information. My query function uses drop down boxes - one is a date and the other is text info. When I run the query with the date and the text info ...
willie's user avatar
  • 1
1 vote
2 answers
24 views

Importrange Query importing correct OR statements, but not refining by date

I have a formula pulling relevant columns from a different document. It is working well except for the last part regarding the dates. It is seemingly ignoring that part of the formula and returning ...
Salt_Tea's user avatar
-1 votes
1 answer
16 views

QUERY returns parsing error

My query is not working but I can’t find the problem. =query(Sheet1!A1:AC; "select * WHERE H>="&E11&" And I>="&A14&" And J>="&B14&) ...
Blacky's user avatar
  • 1
0 votes
1 answer
28 views

Import certain columns when one column contains a 5 digit number

I was trying to use Query on this, but read that query doesn't work well in a column with mixed data. What I have is a financial spreadsheet where Col3 either has the words DEBIT or a check number. ...
Salt_Tea's user avatar
2 votes
1 answer
53 views

ImportRange Query Formatted Incorrectly

I have a spreadsheet that I want to pull data from another spreadsheet. This is my formula: =query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/...
Salt_Tea's user avatar
2 votes
1 answer
44 views

How do I exclude a text value from a count in a Google Sheets query statement?

I have gotten an output that works for my sum, but I need to exclude one value in count(D). I want to exclude from the count in column D all cells containing the text ZERO. I've been researching and ...
Larry OBrien's user avatar
0 votes
3 answers
27 views

Finding strings from a list between 2 string conditions that are part of the list

In Google Sheets, I have a list of unique strings that I want to filter based on two conditions. These conditions are two strings within that list. Ultimately, I want to find all the strings, ...
pfnanc's user avatar
  • 43
1 vote
2 answers
32 views

Finding preceding n results from a list based on conditions in Google Sheets

I have the following list in a Google Sheet: List Apple Banana Pear Grapes Kiwi Mandarin Papaya Orange Tomato Plum Watermelon Based on these two following conditions, I'm trying to get ...
pfnanc's user avatar
  • 43
0 votes
2 answers
22 views

I wanted to set the maximum value of each unique input as active

In the example data below, for each unique SYS Name, the Status column is marked Active in the row with that SYS Name's highest Serial Number. In Status, Column C, for each unique Sys Name the row ...
Vintikon Indonesia Perkasa's user avatar
2 votes
2 answers
164 views

I want to sum a column in table A when a criteria is met in table B (per row)

Table A: Exp Inc Cat $10 Car Repair $300 Salary $5 Car Repair $300 Salary Table B: Cat Sum Car Repair $15 Salary $600 I have been searching query, sumif and other commands to generate ...
timindaburgh's user avatar
1 vote
1 answer
22 views

Keep matching columns aligned when stacking ranges from different tabs that are missing certain columns

Since a while back, I have been trying to find an alternative to Power Query in Google Sheets to combine several sheets of data into one by matching on column letter. For example, in tabA I have the ...
CMM00's user avatar
  • 11
-1 votes
1 answer
25 views

Google Sheets Auto Categorize Budget from Statement

I have a Categories sheet and a Statement sheet. The Categories sheet contains a list of all possible categories, and the Statement sheet is an export of my credit card. How can I automatically ...
user325057's user avatar
0 votes
1 answer
17 views

SumIfs, looking to match part of a string in criteria range with criteria driven from another cell

=SUMIFS('Unspecified Clean URL - Freefor'!B:B,'Unspecified Clean URL - Freefor'!A:A,"*Orlando*") I can manually type in the City Name I am using as criteria, but I have a column of them and ...
monooptical's user avatar
0 votes
0 answers
17 views

Googlesheets Filter or Query, to select values matching a Row by value and Column by IsBetween date range

I'm attempting to make a general Profit and Loss report in GoogleSheets. The data I am using is in a Summary tab Summary by Purchase Category. Each row in Col A represent a category, and Col D:O ...
Eli's user avatar
  • 1
2 votes
1 answer
36 views

Rearrange columns in Google Sheets

I have data in Google Sheets that I want to rearrange. In each row, starting from the 4th column onwards, there are repeating column pairs of Favorite Fruit # & Favorite Color # where # indicates ...
user323956's user avatar
1 vote
1 answer
24 views

Formula to check if a form is filled out each week

The spreadsheet we are attempting to construct using Google Sheets takes form responses across multiple weeks (which come from the same form) and checks to see if that form has been completed for that ...
Swarit Srivastava's user avatar
0 votes
1 answer
29 views

Improve reliability and speed in Google Sheet query array

In Google Sheet, I'm using a rather large array of queries to select data from X number of Sheets. The number of Sheets is unknown, and manually entered into a list from which the queries pick up ...
pheak's user avatar
  • 3
1 vote
1 answer
167 views

Stop Google Sheets from removing trailing zeros

Can anyone suggest a Google Sheets formula to stop removing trailing zeros? (but allow truncating to 6 digits after decimal? 00.000000 29.9918650 -93.958005 29.991865 -93.958005 (1mi:29.991865:-...
Most Interesting Man In World's user avatar
0 votes
1 answer
44 views

Return only those rows with a date on or before today using Query and Importrange

In Google Sheets I have a QUERY where I want to import only those rows where the dates in Col23 are on or before today's date. This is my current formula: =QUERY( IMPORTRANGE( "...
user321359's user avatar
1 vote
1 answer
52 views

Google Sheets Query [duplicate]

With reference to the question how to remove sum label from query, I have a similar situation. Where would I put the LABEL sum(E) in this formula? =if(($B2="weekday"), ifna(QUERY('Base Data'!...
Simon French's user avatar
1 vote
1 answer
98 views

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

I have a Google Sheet, that I am using as a tracker for a game. This was not written by me, just passed down, and I am having a hard time trying to decipher the issue here. As per the title of the ...
Roland410's user avatar
0 votes
2 answers
228 views

Google Sheets QUERY to return if contains multiple selection and all other values

I have a data set similar to the image in cells A5:D31. I am trying to write a QUERY function that will return the records that match the "filters" in range A2:D3. In this example, the query ...
Elaine's user avatar
  • 43
0 votes
1 answer
58 views

Column Identifiers as Described in Query Language Reference (Version 0.7) not working

In the Query Language Reference document found at https://developers.google.com/chart/interactive/docs/querylanguage#Table_used_in_Examples it indicates the following as properties of data tables. &...
Philip Wilson's user avatar
1 vote
0 answers
32 views

How do I build a formula to automatically select from dropdown categories column based on strings/text from another column?

I'm hoping to build a formula that automatically selects a category based on keywords/phrases from an imported bank statement. This is a very similar question that Ryan Voigt has asked back in Feb ...
user316684's user avatar
1 vote
0 answers
20 views

Google Sheet Query function [duplicate]

I am just wondering if below code is possible to convert in Google sheet function QUERY(), please see query below: Query: SELECT * FROM tblDate WHERE Date IN ('1/1/2000','1/23/2001','3/1/1996','6/23/...
DodZ's user avatar
  • 11
2 votes
1 answer
163 views

Can't remove header from mathematically generated column in QUERY

I have the following formula in D1 of my Google spreadsheet: =TRANSPOSE(QUERY(B:B, "SELECT "&A1&"/Col1")) It produces the header quotient(5()) in D1 that I don't know how ...
Anton's user avatar
  • 123
1 vote
0 answers
205 views

Google Sheets Query doesn't return all data

this is my first time posting and I am a beginner with Google Sheets. I am trying to use QUERY to return 3 columns of data with a condition that the number column is greater than 0. Here is what I ...
Sabrina Hamilton's user avatar
1 vote
1 answer
167 views

Multiple large GOOGLEFINANCE formulas make spreadsheet unresponsive

Problem In Google Sheets I have huge GOOGLEFINANCE formulas that return accurate results however the sheet is often unresponsive, and can take a few hours to recalculate when reloaded. Is there a way ...
Varun's user avatar
  • 11
0 votes
2 answers
612 views

Query function returning blank values instead of text in column with both text and numbers [duplicate]

I'm using this formula: =QUERY(A1:M;"SELECT D") COLUMN D contains rows with numbers and others with text strings, but the QUERY is only returning the numbers and the text strings are showing ...
Juan's user avatar
  • 11
1 vote
1 answer
34 views

How to sum data on one row from multiple selected Google Sheets

I am tracking paid advertising key performing metrics on both Google & Facebook ads platforms on two separate Google Sheets, however, I'd like to combine both datas collected into one master sheet....
alphex111's user avatar
1 vote
0 answers
11 views

Google Sheets query with sum and date? [duplicate]

I'm trying to write a query from the following table: columns for date (A), description (B), amount (C), category (D) I have this query: =query(Transactions!A2:D501, "select D, sum(C) group by D&...
Luke's user avatar
  • 11
0 votes
1 answer
348 views

How can I query columns instead of rows in a =QUERY?

With this formula, I can get a list of the rows with the highest total =QUERY(A2:D5, "Select A,D Order by D Desc Limit 4") But I can't figure out how to do the opposite, find the columns ...
stackers's user avatar
  • 103
2 votes
2 answers
80 views

Query form data by date to return counts by item and category

I'm a teacher and need help with a Google Form that collects the following info: Timestamp Name Class Lunch option All of the data comes into a Google sheet. I'm using successfully using the QUERY ...
elbennet's user avatar
1 vote
3 answers
91 views

Google Sheets Query: Selecting column, can only order descending

The following query works for me in google sheets: =QUERY(A3:A,"SELECT A order by A desc") Changing desc to asc however does not, instead returning #REF!: =QUERY(A3:A,"SELECT A order ...
Wiley Rush's user avatar
0 votes
1 answer
58 views

QUERY function to return records with multiple criteria

I have a dataset on Google Sheets similar to below: Name Team Account Date Jennifer East Meta 5/1/2023 Steve East Alphabet 4/1/2023 Claire West Google 4/23/2023 Roger West Apple 6/23/2023 Bob ...
Elaine's user avatar
  • 43
1 vote
1 answer
51 views

Google Sheets QUERY function to return records with multiple filter criteria based on cell reference

I have a dataset on Google Sheets similar to below. Name Team Account Date Jennifer East Meta 5/1/2023 Steve East Alphabet 4/1/2023 Claire West Google 4/23/2023 Roger West Apple 6/23/2023 Bob ...
Elaine's user avatar
  • 43
0 votes
2 answers
4k views

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

I have data in a sheet called "PASTE HERE" that I want to import into another sheet in the same workbook. I don't want to use IMPORTRANGE because then copying the workbook would necessitate ...
LJNCRAFT's user avatar
2 votes
1 answer
291 views

How to apply ArrayFormula on a RegexReplace Query formula so that it autopopulates for all values in Column A?

I'm trying to create a single string for each product that includes different unit prices tied to purchase quantity. For example, a product might have a unit price of £10, but the unit price drops to £...
Richard Parnaby-King's user avatar
0 votes
2 answers
36 views

Google sheets - copy adjacent cells if value is identical

I have a table like this Letter Selected letter Number A B 1 B D 2 C 3 D 4 I'd like to have as a result: Selected letter Number B 1 D 4 I tried to compare the two firsts columns to ...
Dave Loepr's user avatar
0 votes
0 answers
40 views

Script to determine time after a dropdown status is changed (utilizing the edit history)

I have a Google sheet-based simple CRM for leads from Facebook ads. When I import leads into the sheet, I assign them the status of Raw in a dropdown column for status. My team then contacts them and ...
Usama Naveed's user avatar
1 vote
2 answers
71 views

Add cell value in query

When doing a multi-sheet query, I would like to bring in the value of a cell (A2) from each source sheet to a new column in the results. The query: =QUERY({CCL!A4:M; HOOD!A4:M; AAL!A4:M; BAC!A4:M; ...
A. Herskovitz's user avatar
3 votes
1 answer
48 views

How to add a column in query that adds 1 year to date column

I have a Google sheets with a bunch of sheets for each vehicle type. Each sheet is formatted the exact same: column A is the unit number, column B is the inspection date, and column C is the status (...
Spencer Lowery's user avatar
0 votes
1 answer
219 views

Query ignoring text

When I share data with sub-subcontractors, I use the QUERY function to return a subset based on a company name match. I never had any issues in the past, but lately QUERY has not been returning values ...
Elle's user avatar
  • 1
3 votes
1 answer
72 views

Filter a list of lottery results for those matching at least 4 numbers

I have a list of 3,000 winning lottery numbers. Each winning lottery number is on its own row and is comprised of 6 individual numbers, each in their own column. The winning number's draw date is also ...
Felipe's user avatar
  • 33
1 vote
0 answers
35 views

Google Sheets - pull multiple lines of data from Workbook1 based on A1 in Workbook2 [closed]

Ok. So I've been all over this looking for an answer to my problem. I found so much helpful info, but none of it quite solves my problem. So I am here to ask the experts myself. I work for a ...
user312381's user avatar
0 votes
1 answer
122 views

How do I return the value of a specific cell within a range on Google Sheets based on current date?

I have a spreadsheet that I'm using to track weekly performance metrics and want to create a summary page that only shows me the value of each metric for the current week. The worksheet is currently ...
Pascale's user avatar
1 vote
1 answer
620 views

Google Sheets Query, filtering with a range of values

I want to query data by checking if the data_range's column C (invoice#) matches this tab any value in column B (invoice#), while this tab column B will have variable data size ( copy from another ...
Seth YEUNG's user avatar
0 votes
1 answer
47 views

Formula to check is cells are blank. If the cell is not blank then assign a value

I have a data set on Google Sheets where for example, Name Stage 1 Date Stage 2 Date Stage 3 Date Stage 4 Date Bob 3/1/2023 3/5/2023 3/31/2023 4/15/2023 Joe 2/1/2023 Zoe 3/21/2023 4/1/2023 4/15/...
Elaine's user avatar
  • 43
0 votes
1 answer
24 views

Query to group files together by a unique box number and return the min/max range

I have a Google sheet that list of files with a corresponding box number(Col1)labeled "Box Number". I want to be able to gather all files by each unique box number and then return the min ...
NateM's user avatar
  • 13
2 votes
2 answers
159 views

Sum of all numbers from many columns that match text from multiple rows in another column

I have some data from analytics that I need to combine somehow and trying to find the best way of doing this. I have data similar to the following: URL Sessions / 59 /?variable=1 2 /?variable=2 37 ...
manc's user avatar
  • 135

1
2 3 4 5
19