Google Sheets allows you to automate tasks using Google Apps Script, a JavaScript-based language. Create a Script: Go to Extensions > Apps Script to open the script editor.

How to add scripts to Google apps If you’re comfortable with JavaScript, you can write your own original programs. Just open Docs or Sheets and go to Extensions, then click on Apps Script.

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce 'if' statements and learn how to ...