Hide Rows In Google Sheets Based On Value Of Cell

I am a fan of Google sheets for collaborative work.

To manage an ongoing Todo for the development of Super Progressive Web Apps WordPress Plugin, me and my partner uses Google sheets.

We use data validation to set the status of an assigned task. Once the task is done, it is marked as Done. The following script cleans up our Todo each time we load the sheet by hiding the completed tasks.

function onOpen() {
  var s = SpreadsheetApp.getActive().getSheetByName('Todo');
  s.showRows(1, s.getMaxRows());
  
  s.getRange('D:D')
    .getValues()
    .forEach( function (r, i) {
    if (r[0] == 'Done') 
      s.hideRows(i + 1);
    });
}

Go to Google Sheets > Tools > Script Editor and add the above code. Replace highlighted parts with the column you have the conditional data and the value to check for.

Of course, hidden tasks can be easily brought back, so the history is safely recorded.

Hope you find it useful.

Hello, I am Arun Basil Lal. Thank you for reading!

I am a WordPress product developer and creator of Image Attributes Pro. I am passionate about solving problems and travelling the world.