Conditionally display record(s) based on status of another group of records

[Jigar_Patel]

I have a group of records called “Round 1 Tasks”, when these Tasks are marked as complete I would like to automatically hide those and display “Round 2 Tasks” and so on.

I know I can do this via the scripting functionality but curious if anyone has ideas on how to implement this via filtered views and/or formulas.

Thanks