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
2 answers

How to query an array in Google Sheets?

In Google Sheets i have in a cell an array like [27, https://www.example.com/page1.html, false, false, 1] How can i access its single parts with a formula? I know a way through =SPLIT(), like =split(split(A2,"["),",") - but i would very like, if its…
Evgeniy
  • 2,337
  • 2
  • 28
  • 68
-1
votes
1 answer

Why is nesting the "unique" function not working?

So I've put a few hours into this and I've finally hit a sticking point that I can't figure out. I'm using a players "Code" to pull information from 1 sheet to another. Normally this would be easy but before I pull the information, I'm running it…
LADD
  • 95
  • 8
-1
votes
1 answer

Unable to add a custom menu to Google Sheets

I'm having trouble creating a custom menu. The custom function works as intended. I can see that in the sheet so it's not a permission issue. Can somebody please adivse? Thank you :) P.S I have tried adding only a menu without a button inside to…
Blackhart15
  • 31
  • 5
-1
votes
2 answers

Google Sheets: "Text to Columns", but in single column?

I have a huge data file. Each line may contain one or more entries separated by a pipe: one|two|three alpha uno|dos beta gamma I can use "Text to Columns" to remove the | and put each entry in its own column: one two three alpha uno …
BizzyBob
  • 12,309
  • 4
  • 27
  • 51
-1
votes
2 answers

How to concatenate multiple columns and then apply an arrayformula to return data for all rows

he exact opposite of what I am looking for. Also, I don't wish to specify individual cell after cell because I think though it can work using & then dragging, it will be a bit messy. Is there a way I can tweak my formula below to perform this task?…
Anne Vandu
  • 103
  • 10
-1
votes
1 answer

How to display the values in another sheet in descending order using v look up

Please help me to find a solution which am trying to sort out. my query is i want to display the values in another sheet using v lookup formula in descending order.
Dilju Sunil
  • 1
  • 1
-1
votes
2 answers

google sheets, Make letters separated by comma given number of following columns. Not using app script, just formulas please

I'm using the query function in google sheets... I want to select columns F to AB. I need a cell that has the output F,G,H,I... ,AB so I can put it in the Select statement. This formula should have 2 inputs, the starting letter (F in this case) and…
jason
  • 3,811
  • 18
  • 92
  • 147
-1
votes
1 answer

Hide the duplicate values of a column

I want to hide the duplicate values of F column. QUERY('Orders'!A:G,"SELECT A, B, C, D, F, E WHERE G = 'Accepted' label A 'Time', E 'Delivery Address'") gives me the F column and i need to hide the duplicate values of that column. Now i'm doing it…
Imtiaz
  • 143
  • 1
  • 1
  • 8
-1
votes
1 answer

Multiple "and"s using Google Query

I am trying to run multiple queries on a table using Google query. I have been trying to sparse the dataset using the a,b,c columns using multiple criteria for each column using an AND combiner. If one criterion is removed then I want the remaining…
Cameron Macleod
  • 1
  • 1
-1
votes
1 answer

how to do the conditional formating for based on the limit of the characters in google sheet

I want to have conditional formating based on the length of the chars of the cells in the column. if the length>100 then mark it red and possibly in another cell, count how many reds or how many cells are length > 100. How can i do it?
PythonDev
  • 41
  • 1
  • 2
  • 8
-1
votes
1 answer

Google sheet checkbox

I am sharing the sheet with you . The sheet i am sharing is not the sheet from my company , this is the sample sheet . The same function we will do in main sheet . In sheet 1 there is check-boxes and names and age . In sheet 2 there is name and age…
Manish Dash Sharma
  • 9
  • 2
-1
votes
1 answer

Google sheets, ArrayFormula, Query resulting the same item

when i run this formula, it works fine for one row only. =ARRAYFORMULA(LOWER(IFERROR(IF(C1:C="test",QUERY(IMPORTRANGE("sheet_ID","Master!A2:AG558"), "SELECT Col14 WHERE Col12 contains '"&$A$1:$A&"'",0),sheet5!L3:L),))) But if there are more rows, I…
greenszpila
  • 193
  • 1
  • 1
  • 14
-1
votes
2 answers

Calculated field over list of values

Given this table of data: I'd like to produce this pivot table: I have an inkling this can be done with the calculated field, and SUMIF, but am not able to get it to work. I think the main blocker is that I'm not able to find good documentation…
dameshgarm
  • 1
  • 3
-1
votes
2 answers

can I sort the order of data being returned from filter function

I am using the filter function to filter a subset of data which works perfect. However, I really need that data to be output in a particular order, in this case based on the value in one of the fields. if you have the following data set Name Qty…
datafarmer
  • 43
  • 1
  • 1
  • 9
-1
votes
2 answers

Sum of matrix values, conditional, with infinite rows and columns

I have 2 sheets: "Planning" and "Utilization" (example) Planning: Employees assigned to projects for each week. Some projects are not fixed but need to be simulated (checkbox = true). Utilization: Shows the utilization of each employee for each…
Mara
  • 371
  • 5
  • 16
1 2 3
…
96 97