I've got a workbook (is that what they're called in google sheets?) with several different sheets. I need to make it so that User1 can only view and edit Sheet1, User2 can only view and edit Sheet2, etc. However, Users 3 and 4 need to be able to view and edit all sheets.
This seems like it'd be simple, but I can't seem to figure out how to go about it.
Publishing the sheet doesn't seem to allow editing, and it doesn't look like you can prevent viewing through the Protect tool.
Ultimately, I need to have several sheets that users enter data into, say Sheets1-10, and a couple of sheets that reference the data in Sheets1-10. Each of the sheets in Sheets1-10 need to be visible only to particular users.
Right now I'm headed in the direction of creating Workbooks1-10 with just the single sheet in it and a master workbook that references those, instead of just the one workbook, but this feels like it will get quite cumbersome as more users are added over time.