I would like to allow users to edit a Google Spreadsheet, but not be able to revert them to prior versions. Is this at all possible?
The spreadsheet we use keeps track of snacks consumed, so anytime anyone goes into the break room and grabs some snacks, they go in and update the spreadsheet.
Each user has their own tab and there is also another tab that keeps track of items for sale and their price, and another tab that totals.
So the spreadsheet is constantly getting updated several times a day.
However, if at any point in time someone goes and reverts to a previous version and I don't catch it, extremely quickly everyone else starts then updating an old spreadsheet and it all gets out of whack.