I have a Tasks table, which has a Status field (Started, Done, etc) and a multipel link to projects table. In project table I have the lookup field, which shows me links to all tasks in that project. I can enter tasks here and also click to see task status, etc. This is perfect.
But in the tasks table, when a task is marked as Done, I just want to hide it from both tables. I have tried multiple formulas and rollupfields, which does what I want but they are just a text list of tasks. I have also created a view hiding “Done” and then filtered that view in the lookup, but nothing happens.
Example: This record has all tasks marked Done, which the rollup field sees. But the linked field does not: