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

Set start and end date to current month Google Anaytics API

I'm setting up Google Sheet report using the Google Analytics app to generate a custom report, I've spent days searching for info on the subject all over the web for an answer to set current month for the report. I can set start and end date with no…
Samuel Ramzan
  • 1,770
  • 1
  • 15
  • 24
0
votes
1 answer

Google Sheets Query Extract Value by Max Spend

I'm running a Google Sheets report on our Facebook marketing campaigns and I want to use a query to return the best performing ads in each campaign by spend. The data is set up as follows: Campaign Name Ad Name Link …
Alex
  • 11
  • 5
0
votes
2 answers

summary of several google sheets in one another sheet

Hi have several sheet in a single google sheet for each of the months with some data. I want t have a summary sheet (annual) with some info I am after. For example, in a sheet called Jan I have the following Cell A B C Date Cat…
lollah mullah
  • 23
  • 5
0
votes
2 answers

Google Sheets Query() Function Returning Unexpected Data

I am having trouble with the QUERY() function in Google Sheets. I'm not certain I am using the correct function to generate the required data. I am far more comfortable with T-SQL, but my wife needs a mailing list generated from her current google…
THANOS--WAS--RIGHT
  • 63
  • 8
0
votes
1 answer

Create UI on top of google sheet

I have a google sheet with some data, say Roll Number and Name. Now I want to create UI for the google sheet with an text box name and have option search When I enter name and click search, I should get all the records with that particular name. How…
user650521
  • 583
  • 1
  • 9
  • 23
0
votes
1 answer

Multiple spreadsheets imported into one using IMPORTRANGE

I am trying to combine multiple spreadsheets into one master spreadsheet by using IMPORTRANGE. Tried the following: …
Yura F Kleban
  • 71
  • 1
  • 6
0
votes
1 answer

Google Sheet "master" to populate "child" on different tabs

I'd like a main "master" Google Sheet to write to separate sheets of another "child" Google Sheet, based on the a Status condition. If a project is "Finished", "Approved", or "Ready", these would show on their own tab. I figured it out with…
Scott Haugaard
  • 3
  • 1
0
votes
2 answers

QUERY returns incomplete result set

I'm using the following formula in a spreadsheet: =query(importrange("https://docs.google.com/spreadsheets/...?usp=sharing","Gmap List!A:G"), "select Col1,Col2,Col3,Col4,Col5,Col6,Col7 where Col7 = 'Deer Valley'",1) It produces the following…
Dave Bird
  • 3
  • 5
0
votes
1 answer

Google Sheets - Query if Date is Before Today

I have a Google Sheet that includes a list of dates that documents need to ON our website, and dates documents need to come OFF of our site. What I'd like to do is create a second tab that includes only the documents that need to come off the site…
crossbeats
  • 65
  • 1
  • 14
0
votes
1 answer

Google Sheet scripts

I created the following script to sort data on certain pages in google sheets, and it will only run the second function and not the first one. I am new to programming and switching over to sheets from excel. I am sure its something small and…
Mathew Reed
  • 1
0
votes
1 answer

Mismatched range sizes in FILTER()

I have a pivot table of info, with totals (the totals columns contain the word "Total"), that I would like to process further. I created a new sheet and use =ARRAYFORMULA('Pivot Table mins'!A:B) to grab the first two columns. But then I want to…
Brittany Greve
  • 1
  • 1
0
votes
1 answer

What are considered in URL Fetch calls limits of Google Apps Scipt

I use Google Sheets and its Script Editor to handle data of our customers. Today, I faced this error: Service invoked too many times for one day: urlfetch. Google puts limits of 20000 calls/day for consumer users.…
Hossein
  • 720
  • 1
  • 5
  • 7
0
votes
1 answer

Google Sheet: Program a button to add/minus a calculated value to a column of cells

The Google Sheet used is here. Under "Medication Record" tab, there are two buttons with "+" and "-" sign. I want to write a macro such that when I click on the "+" sign, the value of cell M4 gets added with a value of H4*x*y, where: x = 1 if J4 =…
Phi Yen Nguyen
  • 13
  • 3
0
votes
1 answer

#ERROR! occurs, but disappears when clicking on the cell and pressing return

I have a google sheet with some script attached. There's an onOpen() function that creates a menu in the UI which is a list of columns that can be sorted. The individual sort functions, called by selecting a menu item, are variations (with different…
David
  • 131
  • 8
0
votes
1 answer

Effectively display a chunk of data in a single cell

What is the best way to include a large chunk of readable data (with line breaks) in a single row without making that row's height grow to fit the data. As an example, if I want to view the full transcript by clicking on the GPA cell: row: Name …
Eric Henry
  • 3
  • 1
1 2 3
…
96 97