I have a custom function as a Google Spreadsheet script, which depends on some other cells\' values. It runs ok the first time I put it in a cell, but then when I change the data in the other cells it
This question already has an answer here: How to fix 'TypeError: Cannot call method "getRange" of null' in Google Apps Script
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
I have this script: function开发者_运维问答 onEdit(e) { var sheet = e.source.getActiveSheet(); var range = e.source.getActiveRange();
I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into anothe开发者_C百科r cell.
I have a Google Form where users开发者_如何转开发 enter the data, is there anyway I could get the data in email when the user has submitted data?
I\'m using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I\'d like it to just
I have a Google spreadsheet where I keep a list of bugsand whenever I fix a bug I change the status from \"Not Started\" to \"Complete\". I want to write a script for the Google Docs spreadsheet such
I like writing my own formulas inside of Google Docs Spreadsheets. But often what I want to do is very similar to a function that already exists. As an example, I couldn\'t find a function to turn a d
I have a simple script that will send out a bunch of emails but these take time to send and I want to show the user a scrolling window with the emails addresses as they are sent (or, a progress bar wo
加载中,请稍侯......