Can we have a 2nd page with sorted data where we click on hyperlinks and it jumps to a tab where that data is sorted? That way nobody is sorting the main sheet and the main sheet is just used for data entry.
I made a 2nd page with some ideas
View attachment 1052043
If people cant follow the instructions to do a filter view, that doesnt change the view for anyone else, they also are not going to go to a separate tab to click the links.
The problem here is that the sheet has had enough responses that its being changed by all of the following groups:
1. Well meaning people who make a mistake thinking they are only sorting for themselves
2. People who dont really care if they are sorting for themselves or not, just poking around
3. People who are actively 100% trolling
I havent dug into google sheets enough to know if this is possible, and this is both not a part of TMC, and, not something I am personally invested in... but with that being said I wonder if there is a way to make a google forum (for data entry) and have people enter their data in that, and have it feed into specific spots in the sheet (and then making the sheet itself read only for most except a few who have demostrated they are helping with the sheet programming etc)
I know a google form can do that, but I havent tried making a form from a google sheet, and trying to do it that way (vs making the form first, and having it link to a blank sheet). Anyway, unless some way of locking the sheet down is implemented, its going to continue to be vandalized / victimized, either accidentally, or "accidentally on purpose" (or just straight on purpose, like the issue with the colors repeatedly being changed or vins being marked yes / entered, etc).