I'm using two sheets, one with the main values and reference datas.The second sheet is for price calculation.I use =Filter to get the values from sheet one where Sheet1!E2:E <> 1.How can I get the row from Sheet2 deleted when the value is no longer inside the Filter Condition?
Conditional deleting in Google Spreadsheets
google spreadsheets