I usually create Google Sheets that have several tabs. Usually the audience of each tab should be completely separate.
However it makes sense to keep these tabs in the same sheet since I like to have a final summary tab that aggregates data from all these sheets.
Is there a way to share the same Google Sheet but by giving different viewing rights to each tab?
I thought that restricting a sheet would work. Turns out that this is only about who can edit a sheet. Here are the instructions:
click on tab > protect sheet > set who can see the sheet