I have a spreadsheet file that has multiple tabs.
Each tab is intended for a specific person.
Seeking your guidance please on how I can let that 1 person only have access to a specific tab within my master spreadsheet file? Thank you so much!
Creating a separate tab in the sheet for each person is just going to lead to a lot of unnecessary maintenance as you would have to design multiple screens in the app that look the same and set up multiple visibility conditions conditions.
I think you would be much better off merging all of those individual tables into a single table and then apply row owners to an email column in that table. Set everything up once and then you can add an many users as you want without have to create new screens. You wound only have to add data to for new users into the same table.
2 Likes