I have two Google Sheets.
One is a Master sheet which I store on my google drive and contains sensitive information.
The other is a shared sheet which I share with Joe, only part of my sheet is visible.
Joe has access to the shared sheet and would like to edit with comments on its content.
I’d love to be:
- notified when Joe has updated the shared sheet
- take the updated comments from the shared sheet and enter back into my master document
Does anyone have any idea if this is possible?