Menu
Is it possible to use a Google Spreadsheet function in a Google Apps Script?
There is a ton of documentation about going the other way around, i.e. using Google Apps Script functions in Google Spreadsheets, but I haven't found an answer to this.
For example, let's say want to calculate a standard deviation on some data in a JavaScript array. Can I use Google Spreadsheets' STDEV function?
952
Click the tab of the sheet you want to duplicate, then select Duplicate from the menu that appears. A duplicate of the sheet will appear in the sheets toolbar. It will be named as a copy of the original sheet, such as Copy of May. If you want, you can rename the sheet.
You can have multiple scripts in the same script file and you can have multiple script files as well. If you click on the small downward-facing arrow at the right of the Script file name, it will show you options to rename, delete, and create a copy of the script file.
Unfortunately not it seems. It has been discussed/suggested/requested over the years, but I have never seen any announcements from google regarding this.
(I have edited this post to be less authoritative since I cannot readily find many resources in support of my point. However, I have been following the boards for over 3 years and have come across it at times.).
118
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
