Use this tag for questions about interacting with Google Sheets programmatically.
I try to make clickable an imported image into Google spreadsheet. When I click it to take me to another …
image google-apps-script google-sheets clickable-imageHow to generate an uuid in google sheet (for exemple ccb8a660-91c9-a556-58e0-4fa7-229516872004). …
google-apps-script google-sheets uuid google-sheets-custom-functionIn Google Sheets, when using ArrayFormula with AND formula, I don't get the results as it should be. A|B 2|7 …
google-sheets array-formulasHere 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-queryI'm trying to create a case insensitive regex query in Google Spreadsheets with the regexreplace function. Is that possible? I've …
regex google-sheets google-appsI've seen numerous articles on this but they seem outdated, for instance none of the Google Docs Spreadsheet urls has …
javascript json google-sheets google-spreadsheet-apiI'd like to grab the names in every person's name from this google spreadsheet and put it into a new …
google-sheets google-sheets-formulaI have looked at the question "Is it possible to 'prefill' a google form using data from a google spreadsheet?" …
google-apps-script google-sheets google-formsI have a few Simple Custom Functions that I use all the time. I have recently run into a spreadsheet …
google-apps-script google-sheets custom-functionI'm trying to get this aggregate date comparison working, and I thought I understood the syntax, but it's clearly not …
google-sheets google-sheets-formula