Use this tag for questions about interacting with Google Sheets programmatically.
I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form …
google-apps-script google-sheets google-formsI am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet …
python google-sheets google-api google-api-python-client google-sheets-apiI'm trying to set up a formula with multiple IF statements between number ranges but I'm seeing the error: Formula …
if-statement google-sheets google-sheets-formulaI have several columns in Google Spreadsheet. I would like to count how many cells have a value (number or …
google-sheets google-docsI have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a …
google-apps-script google-sheets google-drive-api google-spreadsheet-apiHow do you get a sub-category column to populate a drop down based on the value selected in the main …
validation google-apps-script google-sheetsI want to do "is not blank" in a custom formula. There is a isblank() function but I can find …
google-sheetsI have a spreadsheet with some values in column G. Some cells are empty in between, and I need to …
google-apps-script google-sheets google-sheets-formula array-formulas custom-functionMy google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to …
google-apps-script google-sheets google-financeI have a column with average(K23:M23) that starts out with #DIV/0! when the K23 through M23 cells are …
google-sheets divide-by-zero