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.

CodePudding user response：

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<>"")}