Would be great if it were possible to write an automation which would automatically share the sheet with people named in cells in the sheet. Ideally with controls to editing rights, etc.
Certain reports we make need to be shared with three particular individuals in the organisation but are intended to be confidential. At the moment, we have to identify them in cells in the sheet and then share the sheet with each of them. Too many operations, and too much possibility for error!
This would be a huge benefit to my team. We have onboarding checklists that have to be shared manually with each person— it would be amazing if I could set an automation on the template and have it automatically share the sheet with anyone who is assigned a task on each created checklist.