Top "Google-sheets" questions

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

How do I connect Android apps with Google Sheets spreadsheets?

I'm trying to do an Android app that needs to work with Google spreadsheet API. I'm new in this, so …

android google-sheets google-api google-docs-api google-sheets-api
How can I filter my search in a column on google sheet which collects data from a form?

I would like to perform a multi criteria search of data in a column- contains data of check boxes(more …

google-sheets spreadsheet google-docs
Google app script trigger not working

I have a google app script which sends email, and i have set a trigger such that it sends email …

google-apps-script google-sheets triggers google-forms eventtrigger
updating existing data on google spreadsheet using a form?

I want to build kind of an automatic system to update some race results for a championship. I have an …

forms google-apps-script google-sheets google-sheets-api
"We're sorry, a server error occurred. Please wait a bit and try again" error when running a function from a custom menu

I have received 341 error notification emails for the below error We're sorry, a server error occurred. Please wait a bit …

google-apps-script google-sheets
How to use for to sum a range in google app script?

I want create a simple custom sum formula in google Spreadsheets using google app Script. function somaDias(range, days) { var …

google-apps-script google-sheets custom-function
How to write to a "Google Spreadsheet" from Excel 2003 VBA

I Have an Excel 2003 file with a line similar to this: I need to click "the button" and it adds …

vba google-docs excel-2003 google-sheets
Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot …

google-apps-script google-sheets google-apps custom-function
If var isnumber, for script

I need to run a script which contains the logic: If isNumber, Then DoSomething. I've run other such if then …

google-apps-script google-sheets google-apps