Scripting

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

This is a video tutorial for one of my most-requested setups: 2-way data sync.  FILTER(), QUERY(), IMPORTRANGE(), and other methods can pull data from one tab or range to another, but they are all 1-way: source to destination. When you want to be able to read more