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

Using ArrayFormula with Indirect to combine sheets

I am trying to combine data from other sheets into a single sheet. I thought I could use a formula to find the last row in each sheet and combine with an Indirect ArrayFormula but that doesn't…
betwixt
  • 31
  • 7
-2
votes
1 answer

Google Sheets Format a Row depending on the contents of a cell in the row

I need help with conditional formating. Essentially the problem is as follows: If cell 'D3' has text in it that starts with the letters 'BLDUK-ORD' then I need the entire row to turn orange. Then if cell 'E3' has any text/numbers in it then the…
Manraj Sandhu
  • 33
  • 5
-2
votes
1 answer

Google sheets query "match" (regex) not working on text cell, but "contains" does work

I have email body text in a column (populated using Google apps script getPlainBody() in my script), and I am trying to query it for a match. Because I will have several OR and AND statements using contains, I would rather use match. However, match…
dims
  • 9
  • 1
-2
votes
1 answer

Google script - limit query results - Form dropdown workaround

As we know, Google has placed a truly unreasonable limit of dropdowns in the forms. I have a dropdown which was supposed to have 1500+ choices. In order to overcome this, I was thinking about a very messy workaround of creating multiple forms. These…
user13708028
  • 315
  • 3
  • 13
-2
votes
2 answers

how to find unique values from two different columns in google sheet?

i am facing this issue right now. i hope someone will help me out. i want to find the unique values from the range column A to column D.
Dilju Sunil
  • 1
  • 1
-2
votes
1 answer

How to add Defined name range to any cell using google script

I am doing freelancing project please tell me how to add defined name range to cell using google script
pratik thorat
  • 1
-2
votes
1 answer

I want to make reverse order of Column using single formula, How can I make it

I want to make column in reverse order, I tried to do it, but it is taking blank value also. I just want the sheet to check every row and flip the row. You will understand what I want from this sheet:…
Khan
  • 33
  • 5
-2
votes
1 answer

I have my own portfolio designed with bootstrap4 &I had used modal for feedback,I need to get feedback of visitors,in Google Sheet without Google Form

enter image description here this image is of my bootstrap modal from modal I wanna to get feedback of visitors I had hosted this portfolio in HTML I need to get feedback without any database using google sheet.
devanggarach
  • 184
  • 2
  • 13
-2
votes
1 answer

How to rearrange data

I am trying to rearrange the data that I have to be displayed differently. From the 4 rows, I have to the 18 rows below as per the image. Please help.
Joshua Ambrose
  • 11
  • 1
-2
votes
1 answer

how to reshape input dataset with formula

I want to work the following. I am using this formula =ARRAYFORMULA(Split(Transpose(Split(Query(Transpose(query(transpose(if(Input!B2:I<>"", ";"&Input!A2:A&"\"&Input!B2:I, )) ,,999^99)),,999^99), ";")), "\")) but it does not give the desired…
user001000
  • 29
  • 3
-2
votes
1 answer

How to sum up the values in each column and ranking each column name by sum of values in google sheet

I have a google sheet with values that is getting populated A B C D E F G H Top scorers Date Player l Player 2 Player 3 Player 4 13 Jan…
user1314404
  • 1,253
  • 3
  • 22
  • 51
-2
votes
1 answer

Can anyone tell me the formula to sum up expenses added "today" to the category "recharge"?

This is my personal finance manager spreadsheet I made with google sheets. Can anyone tell me the formula to sum up expenses added "today" to the category "recharge" ? p.s I know to pull the sum using a specific date.That's not what I want. I need…
Zenix
  • 1
-2
votes
1 answer

How to break transpose at specific rows depending on the cell content?

So I am working on this excel/spreadsheet project where I have to achieve: FROM: (assuming that Fruit is in cell A1) TO: (Assuming that Fruit Summary is in Cell I1)
user141975
  • 11
  • 2
-2
votes
1 answer

Trying to have + on positive and - on negative

This is the code I'm trying to make work... "=IF (C11>0, "+",OTHERWISE "") Trying to make it so that if the cell nect to it "C11" is over "0" It gets a "+" sign, otherwise if it's a negative number, Ex "-5", nothing will show up since the sign is…
Carlos Hernandez
  • 3
  • 2
-3
votes
1 answer

Count how many times appears text across columns

I'm looking for the formula to count how many times appears a color, for example, "red", from B2:D7 if A2:A7 is "B". .
Tes
  • 61
  • 5
1 2 3
…
96
97