Show And Hide Google Sheets Separately For Specific User

I am working on a google spreadsheet for my team members where they can save their logs so I have made a separate sheet for each of them but I do not want to let them see each othe

Solution 1:

Unfortunately your approach is not feasible

As you suspected, the google spreadsheet has only one instance.

So if one user performs any change on the visibility of a sheet, this change will be also visible to all other users that work on the same spreadsheet.

As a workaround, you can create a separate spreadsheet for each user that cannot be accessed by other users.

Those spreadsheets can be synced to a common master spreadsheet that can be seen and edited by you.

You can do this sync with a simple =IMPORTRANGE() formula.