I wonder if the following scenario is possible:
We have a simple sheet in G Sheet (let’s call it Sheet1) with some columns and one column called IsProcessed that can either be 0 or 1.
Is it possible to have another sheet (Sheet2) in the same document that is identical to Sheet1 except that it only contains rows with IsProcessed = 0.
Of course, Sheet2 should be updated in real-time as values in Sheet1 change.
>Solution :
yes. if column IsProcessed is for example D use this formula in Sheet2:
=FILTER(Sheet1!A:Z; Sheet1!D:D=0)
update:
={Sheet1!A1:Z1; FILTER(Sheet1!A2:Z; Sheet1!D2:D=0; Sheet1!D2:D<>"")}