Top "Google-sheets" questions

Use this tag for questions about interacting with Google Sheets programmatically.

Hash of a cell text in Google Spreadsheet

How can I compute a MD5 or SHA1 hash of text in a specific cell and set it to another …

google-sheets google-search-api
Count occurrences of given character per cell

Question For example if I wanted to count the number of Ns in a column of strings how can I …

google-sheets count character bioinformatics
Google Spreadsheet range names

In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more …

google-sheets named-ranges
"MMMM yy"-date in google spreadsheet

I have a google spreadsheet in which I want a date with only the name of the month and the …

google-apps-script google-sheets
getRange with named range google spreadsheet using scripts

Can 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-ranges
Google Spreadsheet sum which always ends on the cell above

How to create a Google Spreadsheet sum() which always ends on the cell above, even when new cells are added? …

google-sheets
Importing data into R from google spreadsheet

There seems to be a change in the google spreadsheet publishing options. It is no longer possible to publish to …

r google-sheets
Getting around circular reference in Google Spreadsheet

I have a google docs spreadsheet with two columns: A and B. Values of B are just values from A …

google-sheets circular-dependency
Google sheets, if statement multiple conditions

Trying 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-function
How can I create a hyperlink in the middle of cell text?

In 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