I have a Google Sheets document that I want to share to many users. However, they must only be able to edit one column. This part seems fine, however, I have numerous other hidden tabs for the purpose of calculations that need to remain hidden (I think I can get this to work by not allowing them to edit these sheets).
The issue arises where I need the history of the document to be hidden as it seems to allow everyone to be able to see all of the background data. Otherwise I will have to resort back to Excel.
Is this another area where Sheets hasn't quite caught up to Excel?