So, we have a Google Sheets that many many users have access to.  There are two tabs, one of which has a filter view accessed through Data-Filter Views.  Once a user selects the Filter Views, they can select the city they need to view information for.The problem is, the information that is then in the filter view part (the city they selected), is all incorrect.  For example, a filter view with the city name St. Louis should have information for things in St. Louis.  However, it's showing information for NY and NJ.  I don't know where this error is coming from...It's almost like it will be fixed and then go right back to importing incorrect information.It is hard to explain so I apologize if it's unclear.  Basically, when there is filtering, incorrect cities are showing up under cities that they don't belong in.  The only suggestion we have had was to redo the filters entirely.  The problem is there is 40 of them.Any ideas?
Filters in a shared Google Sheets importing incorrect information
google spreadsheets;filter