Join Scott Simpson for an in-depth discussion in this video Building custom spreadsheet functions, part of Up and Running with Google Apps Script (2013).
Have you ever wanted to have a spreadsheet function…that did something that wasn't provided by Google Docs?…Well, now you can.…Custom spreadsheet functions let you use a script function…to operate on an input and return an output.…And it's pretty easy.…To make one, I'll start out in a spreadsheet.…This is the spreadsheet that I created earlier in the course.…And I'll go up to Script Manager in the Tools menu.…I'll create a new script…and choose Spreadsheet.…And I'll make some room above the functions that Google gives us.…
I'll create a function called F to C, which will take…value and degrees Fahrenheit and return the value in degrees Celsius.…As with many functions, you can pass the value…in, in this case d, and the return value.…Which is a formula to convert the temperature value.…I'll save and switch back over to my spreadsheet.…Since I just created this, I need to refresh the Script manager…But you shouldn't need to do that when you open up your spreadsheet down the road.…
So, I can type in equals F to C parenthesis 212 parenthesis and hit Enter.…
- What is Google Apps Script?
- Creating and editing files with Apps Services
- Storing data for your script
- Using events and triggers in containers
- Building custom spreadsheet functions
- Sharing your script as a web app
- Serving JSON or XML from your script
- Publishing your app in the Chrome Web Store