Imagine, we have a big table (main table with 100 rows). We have its view where we have applied filters and this view table has 30 rows out of 100 rows of the main table.
Now, we need another view table (view table 2), where we need to see rest of the 70 rows. So basically we need to filter out those 30 rows of ‘view table 1’ from 100 rows of ‘main table’ to get those remaining 70 rows for ‘view table 2’.
How can we do that?
What have I tried so far: I tried creating a checkbox column in ‘main table’ to indicate that a particular row exists in ‘view table 1’. For this checkbox column I used same filters (with if formula) as ‘view table 1’. I tried creating ‘view table 2’ applying the filter of this new checkbox column but it is not working. I shows 0 rows in ‘view table 2’.