Hide & Unhide Sheets Row

hideunhide.gs

//col and row position of status check
const ROW_CHECK = 2
const COL_CHECK = 2

//row and col index to be hide and unhide
const ROW_TO_HIDE = 10
const COL_TO_HIDE = 1

//row count to be hide and unhide
var ROW_HIDE_COUNT = 11


function onEdit(e){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var sheetName = sheet.getName();
  
  //--------------------New script--------------------
  if(sheetName=='Sheet1' || sheetName=='Sheet2' || sheetName=='Sheet3'){
    var rg = sheet.getRange(ROW_CHECK, COL_CHECK);
    if (rg.getValue() != "" && rg.getValue() != null) {
      pasted = true
      var range = sheet.getRange(ROW_TO_HIDE, COL_TO_HIDE, ROW_HIDE_COUNT);
      sheet.unhideRow(range);
    }else{
      sheet.hideRows(ROW_TO_HIDE, ROW_HIDE_COUNT);
    }
  }  
  //----------------------------------------------------
}