Use this tag for questions about interacting with Google Sheets programmatically.
How can I compute a MD5 or SHA1 hash of text in a specific cell and set it to another …
google-sheets google-search-apiQuestion For example if I wanted to count the number of Ns in a column of strings how can I …
google-sheets count character bioinformaticsIn Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more …
google-sheets named-rangesI have a google spreadsheet in which I want a date with only the name of the month and the …
google-apps-script google-sheetsCan the getRange be used to have a named range instead of an area? When I seem to do it, …
google-apps-script google-sheets named-rangesHow to create a Google Spreadsheet sum() which always ends on the cell above, even when new cells are added? …
google-sheetsThere seems to be a change in the google spreadsheet publishing options. It is no longer possible to publish to …
r google-sheetsI have a google docs spreadsheet with two columns: A and B. Values of B are just values from A …
google-sheets circular-dependencyTrying to make an if statement that will return 4 outcomes based on the contents of the cell If the cell …
if-statement google-sheets worksheet-functionIn google spreadsheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com", "search the …
hyperlink google-sheets google-drive-api google-docs