Top "Google-sheets" questions

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

How to highlight cell if value duplicate in same column for google spreadsheet?

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist …

google-sheets gs-conditional-formatting
Conditional formatting based on another cell's value

I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 …

google-sheets google-sheets-formula gs-conditional-formatting
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 …

google-apps-script google-sheets
Check cell for a specific letter or set of letters

In a Google Spreadsheet, I want to use a formula that will output a certain text or number if a …

google-sheets
Count cells that contain any text

I want to count the cells that contain anything within a range. Any cell that contain text, or numbers or …

google-sheets google-sheets-formula
How can I do time/hours arithmetic in Google Spreadsheet?

How do I do time/hour arithmetic in a Google spreadsheet? I have a value that is time (e.g., 36:00:00) …

time google-sheets datetime-format date-arithmetic
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-sheets google-colaboratory
Get the last non-empty cell in a column in Google Sheets

I use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the …

google-sheets worksheet-function google-sheets-formula
Count rows with not empty value

In a Google Spreadsheet: How can I count the rows of a given area that have a value? All hints …

google-sheets google-sheets-formula
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 talks about how …

user-interface google-apps-script google-sheets