How can I use JavaScript in Google Sheets?

In Google Sheets, we can use Apps Script (JavaScript) to create custom functions. In this video we show how we can use just a bit of code to create a custom function that gives us more control and ability to create more complex functions.

A great guide for working with custom functions in Google Sheets is available here: https://developers.google.com/apps-script/guides/sheets/functions

An overview of Google Apps Script can be found here: https://developers.google.com/apps-script/overview (note that JavaScript is almost identical to Apps Script)

Follow me at https://twitter.com/geekitarian and check out http://coding4.us/ for more coding tutorials!

If I’ve helped you learn to code in 2017, please go to http://5000coders.com and let me know!