Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
I'm having trouble figuring out a fairly simple QUERY statement in Google Spreadsheets. I'm trying to use a cell reference …
google-sheets google-sheets-queryI'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But …
google-sheets formulas google-sheets-query google-query-languageI have a query like this =QUERY(B2:C9; "select (C * 100 / B) - 100") in my Google Sheets. What is displayed …
google-sheets google-drive-api google-sheets-queryAnother problem with Google Spreadsheet API. I'm trying to use QUERY() function in order to get all customers from our …
google-sheets google-sheets-formula google-sheets-queryI'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a …
google-sheets google-sheets-formula google-sheets-query gs-vlookup importrangeI have 15 sheets that use the same template, for 15 different users. I would like to make a query on all …
google-sheets google-sheets-queryI have a table: A | B | C BEN | MOSKOW | YES ANTON | IRKUTSK | NO VIKTOR | PARIS | YES BEN | PARIS | YES ANTON | …
google-sheets transpose array-formulas google-sheets-queryHere is what the spreadsheet I'm working with looks like: Summary table (top of sheet) Source data (same sheet, below …
google-sheets google-sheets-formula google-sheets-queryIn Google Sheets, What do I do if I want a cell to display the row number in which a …
google-sheets formulas google-sheets-queryI have a Google Sheet with the following query formula: =QUERY('Contact Changes'!B1:T,"SELECT C,D,E,F,…
google-sheets google-sheets-query