Collaborative Game Scheduling Advice / Guidance

Question

If someone can point me in the right direction I would be greatly appreciative.  I coordinate scheduling for a youth hockey district in Minnesota.  This past season I setup google sheets to allow the schedulers for individual teams to input the Date, Time, and Arena for their pre-loaded schedule (basically who plays who).  This was done for 14 leagues, 133 teams, and 962 games.  I pre-assign the who plays who and then the schedulers collaborate to determine date / time / arena for each game.
The google sheets setup I built worked better than what we had been using (paper) and the schedulers enjoyed the collaboration.  Each league had its own tab in the spreadsheet.  BUT how I set it up was when a scheduler selected a team in a league the Macro I wrote only displayed the games for that schedulers team and everybody who was working on games in that league had their view resorted so they saw the same thing.  A bit of frustration in the collaboration that we worked through and we ended up have a very successful scheduling of all leagues, but I am looking to do better.
Can someone point me in the direction of a configuration that would allow multiple schedulers to be working in the same league but only see their own teams?  The key is we also want the date / time / arena fields to update in real time like the first system worked with the enhancement that one scheduler cannot change the league view for all.
thoughts on this are much appreciated.

Gill K · Accepted Answer

I tried to create this in your sheet, but I think I was running into issues with your macro, which was hiding rows in conflict with what I was trying to do.  So here is a link to a Forum spreadsheet, demoing what I am thinking of in using Filter Views.
https://docs.google.com/spreadsheets/d/18gFR-6Uqy9LGXmXnhxIlc4HrYeDOqXcTPvfCtS-XlLY/edit#gid=2109285902&range=A1
It takes a bit of set up to create each filter view, and then to save it as a linked option at the top of the sheet.  But it seems to work.  You can test it out by using a second email account, or a scond person, to look at the same tab once you've applied a certain filter, and their view will not be affected.
It uses a column Q where I combine the names of both teams, so we can search both the home and away team names for one specific team name.  But that column could be hidden to avoid any confusion.
Does that seem workable?

Gill K · Accepted Answer

The link seems valid now, but we don't have access rights.  Please change the Share setting to allow anyone to EDIT it, if you would like further help.  Make sure you are sharing just a sample copy of your original, with no sensitive data.  
There are instructions for that in the Sheets Tips for Posting post.

Gill K · Accepted Answer

That doesn't seem to be a valud URL link to your sample spreadsheet file.

Gill K · Accepted Answer

Hi DS Hockey Scheduler,
Have you looked at using Data - Filter Views from the menu bar?
They enable a user to filter columns of data to see just what they are interested in, but without affecting what anyone else using the sheet sees.
See the Filter Views section in this Help post:
Sort & filter your data
Or search on the internet for guides like this one:
How to Filter Google Sheets Without Affecting Other Users
Without seeing a sample copy of your sheet, I'm not clear what your macro was doing, or whether usinf Filter Views would be a replacement for your macro.
Does this help?