Use this tag for questions about interacting with Google Sheets programmatically.
I'm trying to recode all the zip code from Column A into Column B with the formula: =TEXT(A1,"00000") Like …
google-sheets array-formulas google-sheets-formulaSheet.getRange(1,1,1,12) I cannot understand the arguments 1,1,1,12 . What is this - the sheet id or row or what? method getRange(…
google-apps-script google-sheets google-spreadsheet-apiI am trying to figure out how to get labels to show on either Google sheets, Excel, or Numbers. I …
excel google-sheets numbers graphingI'm having trouble figuring out a fairly simple QUERY statement in Google Spreadsheets. I'm trying to use a cell reference …
google-sheets google-sheets-queryI have a Google spreadsheet where I keep a list of bugs and whenever I fix a bug I change …
google-apps-script google-sheets gs-conditional-formattingI have a Google spreadsheet with a column that looks like this: City ---- London Paris London Berlin Rome Paris …
count google-sheets distinctThe Google Spreadsheet looks like can only select one value in the dropdown list. Is there any way to select …
google-sheets google-spreadsheet-apiI have a column like this: What devices will you be using? iPad Kindle & iPad No Tablet iPad iPad &…
google-sheets wildcardI have a sheet with data in cols A through H. I need to determine the last row in column …
google-apps-script google-sheetsI'm trying count the number of cells with the same background color and put the result in other cell with …
javascript google-apps-script google-sheets