New answers tagged


Interestingly enough, collapsing the rows first and then the columns will produce a different result Your question is best and easiest done via a script. The full code is here: The basic steps are: row collapse the grid, using: var r = row.filter((a) => { return a && a != ''}); column collapsing = transpose, row collapse it, and then ...


You can fix the code like this: function onEdit(e) { const sheet = e.range.getSheet(); if (e.range.getA1Notation() !== 'C2' || sheet.getName() !== 'Outbound Parts') { return; } sheet.getRange('I4:I').setValue(false); }

Top 50 recent answers are included