Use this tag for questions about interacting with Google Sheets programmatically.
I have a situation where a script is taking input data and sending it to a spreadsheet. After a while, …
google-apps-script google-sheets google-drive-api google-appsLet's say I have a column which has values like: foo/bar chunky/bacon/flavor /baz/quz/qux/bax I.…
regex google-sheets split google-sheets-formula re2Consider the query run from sheet2 =query(Sheet!A7:A, "Select A,B,C where A='Order'") but I want …
google-sheets google-query-languageI have a Google Slides presentation with charts that are linked to a specific Google Sheets Spreadsheet. As there are …
charts google-apps-script google-sheets google-slides-api google-slidesSay I have 2 columns: (this is extremely simplified) Data = a number Result = Data * 1.2 I can put B2 = A2*1.2, then drag …
google-sheets google-sheets-formulaI'm trying to get the list of all digits preceding a hyphen in a given string (let's say in cell …
regex google-sheets re2I'm trying to create a function that takes in any array and transpose it so that rows turns to columns …
javascript google-apps-script multidimensional-array google-sheets transposeI need to delete 200-300 rows, excluding row 1. The script below is getting an out of bounds error, and it's …
google-apps-script google-sheets delete-rowThe following spreadsheet demonstrates a very odd behaviour of Google Spreadsheets Lookup functions. I've used these functions many times without …
google-sheets google-docs gs-vlookupI 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-query