Category: Google Sheets

To automatically sort data in Google Sheets you can use this Apps Script.  The video above takes you through the steps or you can follow the notes below. function onEdit(event){ var w = event.source.getSheetByName(“Scores”);//Replace Scores with the name of the worksheet you want to sort in var c = w.getActiveCell(); var srtby = 2; //Change […]

A data picker provides a quick and convenient way of entering dates in your worksheet. Fortunately, Google Sheets provides two ways of displaying a calendar date picker. Method 1 In the cell that you want a date picker to appear in type @date Now select Date in the menu A calendar date picker will appear […]