I hope this is the right place for this question, but we'll see!
Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that allows filtering out all child tasks until the parent task's 'Status' field reads "Complete". This would create a nice flow of the next steps for a project filtering into the view once a parent task has been resolved.
The Tasks table has a linked field called "Blocked by:", which links to the same table. Here, users link a record (parent task) that must be completed before they can complete this task.
Is there a way to 'hide' any records that have a linked record whose Status is NOT "complete"? Then, once the linked record's Status is "Complete", by virtue of not meeting those conditions, the child task appears? 🤩
Ideal situation - there are a few team members who use this table– it would be optimal if a single user could customize their own view to operate in this way, rather than creating a script or formula that applies this change for all users.
I'm grateful for any input on this question!