How to Search in Google Sheets 🔍

[@hengzh1440]

I would like to learn how to HideRow with formula by, for example, =IF(AND($A$1=TRUE,$B16=TRUE),HideRow(1))

[@saperis]

I suggest you write a Google Apps Script for something like that.