Hide Row with Checkbox

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 != “TRUE”) return;
SpreadsheetApp.getActiveSheet().hideRows(e.range.rowStart);
}

Leave a Reply

Your email address will not be published. Required fields are marked *