Use this tag for questions about interacting with Google Sheets programmatically.
In the new Google sheets there's a way of formatting a number as a duration. Format -> Number -&…
time google-sheets duration formulasI've generated a server key in the API Manager and attempted to execute the following on my Mac: curl 'https://…
google-api google-sheets google-sheets-apiI want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be …
google-sheets sum google-sheets-formulahttps://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, …
java google-apps-script google-sheetsIs there a function that can fill down data to all empty cells from the row above? If not, could …
google-apps-script google-sheetsis it possible to place the name of the first worksheet in a cell and then use it in a …
google-sheetsI need to write a conditional format rule with a custom formula, that should trigger when the certain cell's (the …
google-sheets gs-conditional-formattingI'm trying to find a link which allows me to download a CSV formatted version of my Google Spreadsheet. Currently …
google-sheets google-visualization google-sheets-export-urlI have a worksheet Movements with two fields: mydate | amount 2009-01-01 | 10.00 2009-01-02 | 13.00 2009-02-01 | 11.00 2009-02-05 | 12.00 2009-02-08 | 52.00 …
google-sheetsI'm trying to get the following formula to work: function setDataValid(range, sourceRange) { var rule = SpreadsheetApp.newDataValidation().requireValueInRange(sourceRange, true).…
google-apps-script google-sheets