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.