How to find the last row of a specific column, rather than the entire sheet. Important notes: * Make sure the variable used to store the row is declared and instantiated outside and above the FOR() loop so that it can be accessed and used read more

The simplest tutorial yet, but one that still gets frequently asked about. This is simply how to hide a row with a checkbox. The script itself is a single active line long! Sheet (to copy) Script: function onEdit(e){ if (e.range.columnStart != 8 || e.value != read more

How to automatically send an email when a condition is met. This uses an installable On Edit trigger and must be authorized. Important Notes: * This uses both .toLocaleDateString() and .toLacaleString(). The former only returns the date “11/13/2020,” the latter returns the date and time read more

When a sheet is a calendar-based list, finding today’s date can be tedious. Here, I show how to open the sheet directly to today’s date.

This has less scripting than my other tutorials, but still shows a powerful use of math and one-time needs in the script.  I’m creating a sales tracker intended for a call center where hours, calls, sales, and services would be tracked for each employee on read more

You can always run custom scripts and functions from the script editor, but sometimes it’s nice to have easier access. Here’s how to create a custom menu with custom functions in that menu.

When you simply Duplicate or Copy a sheet, the protections don’t come with it. Here’s how to copy a sheet while preserving protections.    

Another 3 videos for you this time! Lock Cell After Edit Lock Entire Row After Edit Lock Row with Installable Trigger

Here are 3 video tutorials for moving an entire row of data based on some trigger. The first 2 use checkboxes, the last uses a dropdown menu. Move Entire Row with Checkbox Move Entire Row with Checkbox 2-way Move Entire Row with Dropdown

As a follow-up to my previous video showing how to setup 2-way data sync  in a workbook, this shows how to setup data sync across different workbooks.  The most important difference is that this setup uses an installable trigger rather than a simple trigger, and read more