Google Sheets: Hiding Rows Based on Cell Value Yes/No
Hide and Show Rows based upon Validation Selection You need to add the sheet name and set up the validation for B3. function onEdit(e) { if(e.range.columnStart==2 && e.range.rowStart==3 && e.range.getSheet().getName()==’Sheet92′) {//add your sheet name if(e.value==’Yes’) { e.range.getSheet().showRows(4,9); } if(e.value==’No’) { e.range.getSheet().hideRows(4,9); } } }