Stack Overflow
Stack Overflow

Questions tagged [google-sheets-query]

Use for question about the QUERY function of Google Sheets.

Use this tag for questions about the QUERY function of Google Sheets.

QUERY is a non-standard spreadsheet function. It uses Google Query Language

It could be used together with

Usually it will not be used with

1444 questions
-1
votes
1 answer

How can I query select and change the value of the request in a Google Sheet?

I have a problem changing a value in a Google sheet with this syntax: =query(sheet!cell; "select column order by column " & if(sheet!column:column="value";"value1";"value2")) If I try to only change the value, it works: =query(sheet!column; "if…
Talimbie
  • 1
  • 1
-1
votes
1 answer

How can I do a where clause on an aggregated column?

How can I do a where clause on an aggregated column? Or accomplish similar behavior in Google Sheets simply? For example.. Where SUM(A) <> 0
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
-1
votes
3 answers

Google Sheets Parse Mathematical Expressions in Text Format

Is there a way to take a text in a cell that says 5*5 and to parse to make the result 25... using QUERY function or any of the other built-in functions...?
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
-1
votes
1 answer

Count of unique characteristics in duplicate rows table

My table is having duplicate rows listed based on a duplicates ID column. The duplicate rows may have one or more Characteristic columns having unique values. I am trying to get a count of which Characteristic columns in duplicate rows have unique…
sifar
  • 1,086
  • 1
  • 17
  • 43
-1
votes
1 answer

Query ImportRange with date and location

I currently have a file with a bunch of columns with Date in column 1 and location in column 3. I wanted to pull a specific number based on the date and location. Currently, it just keeps pulling the column header based on the query. Attached is…
itzmurd4
  • 663
  • 10
  • 25
-1
votes
1 answer

chartjs x-axis category label (with data from tabletop.js)

my below code extracts data from google-sheets via tabletop.js as input to the chart.js. the problem is im unable to make the x-axis show. the chart simply displays the y-values itself as x-label. any help, please? var publicSpreadsheetUrl =…
Ted
  • 15
  • 7
-1
votes
1 answer

Multiple cell input with conversion rate from another cell

I'm having a problem with a small accounting sheet I'm currently working on in Google sheets. I have one cell where I can select the currency of income (GBP, USD, EUR) and another cell that auto-updates with the exchange rate on the day of…
Josephina
  • 1
-1
votes
2 answers

How to select more than 2 columns in =QUERY()

I was trying to copy data from Sheet1 to Sheet2 using query. But I want to select MAX(A) and all the other columns where data exists (B,C,D...etc.) and group by B. То clarify, in Sheet1 I have some similar rows which differ in col.A, which contains…
Lyuboslav Alexandrov
  • 65
  • 8
-1
votes
1 answer

onEdit custom selection of edited range

Data gets posted from an external source to my spreadsheet. The data range is across three columns - A, B, C. I can access the newly modified range using the onEdit script. function onEdit(e){ var activeSheet = e.source.getActiveSheet(); …
sharkdawg
  • 958
  • 1
  • 8
  • 20
-1
votes
1 answer

Google spread sheets, query, combine concate columns

I did a search and it seems I can't use concate in the query SQL string. How can I combine two columns that have only strings in each row: C = Firstname D = Lastname Combine = Firstname Lastname =query(RAW!1:1000;" SELECT * ,concate(C,D) WHERE…
F T
  • 88
  • 1
  • 10
-1
votes
1 answer

How to split the cell with user condition like "\t and \n" in google sheet?

My data looks like this: Customer Name:\tAAA \n\n Customer Email:\tAAA@b.com \n\n Customer Mobile:\t12456788 \n\n Customer Message:\n\n\taaabbbcccmessage I want to convert the data like: AAA AAA@b.com 12456788 aaabbbcccmessage in separate cell. I…
Sarath Venkat
  • 7
  • 8
-1
votes
1 answer

Calculating average per month based on month dates

Using the following dataset how can I average weight for each month based on column A for dates in the format month | average weight?
Dharmesh SurajBali
  • 3
  • 2
-1
votes
1 answer

Parse ASIN's and add Hyperlink

Say I get a string like this B01AVAF3AK-40 / B01AVAF5Q2-36. I would like to copy over any ASIN's into new cells on parallel columns. I have been using a combination of =REGEXEXTRACT(A2, "(B[a-zA-Z0-9]{9}).*(B[a-zA-Z0-9]{9})") and…
Avi Kaminetzky
  • 1,489
  • 2
  • 19
  • 42
-1
votes
1 answer

How can I use Conditional formatting formula in the filter in the Gsheets to select 2 or more columns where cells that are not empty in both?

so I have ABCDE columns and I want to see rows of the cells that are not empty in the C as well as D column. how do I do this? I know I can have one column do that but that way it would exclude the information in the other column. Let me know if…
Ujas Vaghani
  • 1
  • 1
-1
votes
1 answer

#Value Error on Query - Google Spreadsheet

I'm trying to combine the data in two sheets into another sheet by using the below code: =UNIQUE(ArrayFormula(query({filter('Sheet1'!A2:B,NOT(ISBLANK('Sheet1'!A2:A)));filter('Sheet2'!A2:B,NOT(ISBLANK('Sheet2'!A2:A)))},"order by Col1"))) It works…
Oralet
  • 349
  • 1
  • 2
  • 11
1 2 3
…
96 97