tagged [google-sheets]

How to make google spreadsheet refresh itself every 1 minute?

How to make google spreadsheet refresh itself every 1 minute? My google spreadsheet is using `GOOGLEFINANCE('symbol','price)` function to retrieve stock prices of my portfolio. Unfortunately, I have t...

How to get the correct range to set the value to a cell?

How to get the correct range to set the value to a cell? I want to set text or number in Google Sheet from script. I want to set `Hello` or number `9` in cell `F2`. I found this code so far: but that...

25 Nov at 06:45

Import data into Google Colaboratory

Import data into Google Colaboratory What are the common ways to import private data into Google Colaboratory notebooks? Is it possible to import a non-public Google sheet? You can't read from system ...

28 Oct at 05:53

Google Spreadheets Scripts: check if cell is empty

Google Spreadheets Scripts: check if cell is empty I want to input a variable in a cell only if the cell is empty. The if statement, however, does not work. Any advice?

How do you add UI inside cells in a google spreadsheet using app script?

How do you add UI inside cells in a google spreadsheet using app script? I'd like to add buttons to specific cells in Google docs spreadsheet. The [apps script UI documentation](http://code.google.com...

Number of days between past date and current date in Google spreadsheet

Number of days between past date and current date in Google spreadsheet I want to calculate the number of days passed between past date and a current date. My past date is in the format `dd/mm/yyyy` f...

24 Aug at 22:0

Add a "sort" to a =QUERY statement in Google Spreadsheets

Add a "sort" to a =QUERY statement in Google Spreadsheets I've setup a simple `=QUERY` statement that will pull targeted rows/columns out of a 'response' sheet and put them into a topic specific sheet...

1 Feb at 10:31

How to label scatterplot points by name?

How to label scatterplot points by name? I am trying to figure out how to get labels to show on either Google sheets, Excel, or Numbers. I have information that looks like this Then I would want my fi...

14 Apr at 08:3

How to define global variable in Google Apps Script

How to define global variable in Google Apps Script I see most examples from Google is they use only functions in a single giant script. e.g. [https://developers.google.com/apps-script/quickstart/macr...

Get Sheet By Name

Get Sheet By Name I'm trying to get the following formula to work: ``` function setDataValid(range, sourceRange) { var rule = SpreadsheetApp.newDataValidation().requireValueInRange(sourceRange, true)...

13 Mar at 13:8