Use this tag for questions about interacting with Google Sheets programmatically.
I'm looking for some expertise with formulas. I've got a raw data source and need to be able to summarise …
google-sheets countif formulasI am adding a unique ID to each submission of the form. Right now, I made that ID the first …
google-apps-script google-sheets google-formsI know that Google Apps Script has a getSheetId() method for the Sheet Class, but is there any way to …
google-apps-script google-sheetsI'm trying to have a similar function to SUMIFS (like SUMIF but with more than a single criterion) in a …
performance google-sheets google-query-languageOkay so I have a Google Form that dumps info into a spreadsheet. On each line I need to have …
google-sheets google-forms array-formulasI've been trying to figure out how to replace commas with line-breaks. I've tried using (/r/n/), char(10), the Unicode …
regex replace google-sheetsI know this looks simple. In a Google spreadsheet, I have a column where I enter time in one timezone (…
google-apps-script google-sheets timezone dst formulasI would like to open a specific sheet of a Google Sheets from a hyperlink in another spreadsheet. I have …
google-sheets hyperlink google-api google-sheets-apiI 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-queryOn a shared Google spreadsheet: I don't want a specific user in my domain to view columns with sensitive data, …
google-apps-script google-sheets