Managing permissions for sheets that will be updated via reports
I have a sheet that I want users to update using a report. It would be best not to open the sheet up to the full universe of users, but new users are added frequently and I don't want to continually be updating the permissions for the sheet or a group. What are the best options for doing this?
The report I am using is filtered to the current user using a contact field in the sheet.