Use this tag for questions about interacting with Google Sheets programmatically.
I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist …
google-sheets gs-conditional-formattingI'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-formattingI want to set text or number in Google Sheet from script. I want to set Hello or number 9 in …
google-apps-script google-sheetsIn a Google Spreadsheet, I want to use a formula that will output a certain text or number if a …
google-sheetsI want to count the cells that contain anything within a range. Any cell that contain text, or numbers or …
google-sheets google-sheets-formulaHow 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-arithmeticWhat are the common ways to import private data into Google Colaboratory notebooks? Is it possible to import a non-public …
google-sheets google-colaboratoryI 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-formulaIn a Google Spreadsheet: How can I count the rows of a given area that have a value? All hints …
google-sheets google-sheets-formulaI'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