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
2
votes
1 answer

How can I tidy up data responses from Google Forms?

Can anyone please help me tidy up Google Spreadsheet data responses after a Google Form with a checkbox has been filled? When someone attends training, a Google Form is filled which automatically populates a Google Spreadsheet with: the training…
McChief
  • 423
  • 1
  • 3
  • 18
2
votes
2 answers

Translating each result row of a Google Sheets QUERY operation via VLOOKUP

I have the multi-column results of a QUERY in Google Sheets, where I want to translate the strings in one column based on a lookup table in another named range. I can accomplish this indirectly with an additional VLOOKUP call, but I'd like to do it…
Joost Schuur
  • 4,417
  • 2
  • 24
  • 39
2
votes
1 answer

Google Sheets Formula to calculate actual total duration of tasks with different start/end dates, overlaps, and gaps

I know I how to do this using a custom function/script but I am wondering if it can be done with a built-in formula. I have a list of tasks with a start date and end date. I want to calculate the actual # of working days (NETWORKDAYS) spent on all…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
2
votes
2 answers

How to fix error IN ARRAY_LITERAL, An Array Literal was missing values for one or more rows

I need to consolidate multiple sheets in one file, no blanks or space. But always got this error: In ARRAY_LITERAL, an Array Literal was missing values for one or more…
Yucute
  • 21
  • 1
  • 1
  • 3
2
votes
2 answers

Using vlookup with repeated interval + split

I have a list with purchase codes and product serial number and would like to know the purchase price of each product. In a second list, I have a column with the purchase code, the serial number of a comma-separated product group in another column,…
Lucas Góes
  • 113
  • 7
2
votes
1 answer

Using RegEx in Google Sheets to transform 1 + 1h into 2?

I'm working on a spreadsheet that handles my company's inventory report. We mark quantities with a number, (1, 2, 7, etc). We mark "holds" in the same cell with an 'h', (i.e. 1+1h, 0+2h, 5+3h) The problem is that we submit holds + inventory…
Thomas Boshoff
  • 21
  • 2
2
votes
1 answer

Query and transpose a long row of data Google Sheets

I have rows of data with a lot of columns, example: Date=Team2:Date Date Exercise 1 Reps Weight Team Exercise 2 Reps Weight 9/18/2019 9/18/2019 chinup 10 2 2 situp 10 3 I want to…
Laila Van Ments
  • 147
  • 2
  • 16
2
votes
1 answer

Problem with getting specified image link using importxml

I am a newbie to importxml and I am having trouble scraping Product data using importxml to Google Spreadsheet. the image element on the webpage is as the following:
Mostafa Saad
  • 33
  • 4
2
votes
1 answer

Pulling data from a Named range in Google Sheets

I'm wondering if this is doable in Google Sheets. I have product and ingredient list in a named range called Goods I want to display a summary of what ingredients are needed in one cell. For example, I want the cell to say for 2 Wheat, 2 carrot. So…
KiloJKilo
  • 465
  • 1
  • 6
  • 16
2
votes
1 answer

How to make a Google query pull only TRUE values from two different columns

I am having trouble creating a query to pull only TRUE values from two specified columns. On the Data tab I only want data to populate in the query if either columns 10 or 11 contain TRUE values. For some reason the query is pulling data that…
Austin Farmer
  • 125
  • 1
  • 1
  • 8
2
votes
1 answer

Perform a lookup to find out values from another column and summarises them using Google Sheets

Example data below. I want to be able to sum the values in Col2 for each occurrence of Col 1, depending on the values in 'Other Cols' that are applied in combination with the value in Col1 Col1------Col2-----Other Cols A---------40-------other…
roger
  • 79
  • 1
  • 6
2
votes
2 answers

Formula to fill a two dimensional grid with computed value from a table

Here is a problem to solve with a Google Sheets formula. I have a big table (sheet “data” with headers on the first row) with those columns: A, product reference B: customer C to F, KPI1 to KPI4 On another sheet, a grid of product references…
PopGoesTheWza
  • 558
  • 4
  • 12
2
votes
2 answers

Unique Values in a Comma Separated List / Unique Values in Multiple Columns

I have some Google Form Data from several surveys that were conducted, where the answer categories shifted across time. I want to find out all the unique choices that were used, followed by the count of all of them. The count will be easy, but I…
khabibul35
  • 101
  • 1
  • 8
2
votes
2 answers

Google Sheets Query get Even/Odd rows in grouped results

I have a long list of rows with dates on the side, and a text field after 01/01/2019 | ABC | ... The list is ordered by date, and may have between 1 and 4 rows per date 01/01/2019 | ABC | ... 01/01/2019 | DEF | ... 05/01/2019 | ABC | ... 05/01/2019…
Jammo
  • 1,838
  • 4
  • 25
  • 39
2
votes
1 answer

How to use a SQL query in Google Sheets to group by a substring

In my table, in Google Sheets, I have a column B called "description" and I'm trying to write a SQL query to group by substrings of column B. Values in B are like "Sell 1 Jan11 300.0/307.5 Strangle" and I just want to group by 'Jan11'. I have a few…
ajg
  • 59
  • 1
  • 6
1 2 3
…
96 97