Automatically remove archived record from cell?

So, I use Airtable to keep track of concerts I book. I have 3 tabs in my base (SHOWS, VENUES, LOCAL BANDS). Once a concert has happened, I archive it which separates it from the rest. I like to keep all the info for each show available so I can refer to it in the future if needed. My SHOWS tab is linked to the other 2 tabs to easily populate the cells.
The problem I’m running into is on my LOCAL BANDS & VENUES tabs, every show I have confirmed for a certain band stays in the “Confirmed Shows” column regardless if it’s active or archived. So eventually, it will look like some of these bands have 10 upcoming shows with me when in reality, they might have 1 or 2 coming up, with 8 in the past. What I want to do is figure out a way to have that record leave the “confirmed shows” column once it’s been archived without deleting them from the archived event.
Is this even possible??