Dynamically assign view permission
I have a contacts column in my Sheet and would like to dynamically share the sheet with these contacts.
Each row has an owner that frequently changes. I'd like to be able to "just" change the contact in the row and with that he gets or losses access to the sheet and its reports.
Is there a solution for that?