New answers tagged

0

The code line that hides the row is sh.hideRows(e.range.rowStart) To avoid that the row be hidden, just remove that line. The code line that clears a a cell content is e.range.offset(0, 3).clearContent() It's clearing a cell in the same row, three columns to the right, i.e. if G3 is edited then the content of J3 is cleared. To clear the content of C3 ...


0

Let me know what you think about this solution. Column D and E can be grouped. Add two extra columns with the formula in my screenshot. Work of the two new columns and update other formulas to reference your new columns. Formula: =IF(C2=true,value("$0"),A2)


Top 50 recent answers are included