Sharing a sheet via an automation
Options
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!
