How to share data with external users and allow some editing

Hi, I'd like to share a sheet with an external user, and allow them to edit update one column only.

If I produce a report, then that will mean they would have to have access to the underlying sheet, which will contain information I don't want them to see.

My plan is to set up a sheet which links to my main sheet, which only features the information that I'm comfortable sharing. Then, publish that sheet using 'Edit by Anyone'. Then I can give 'editor-level permissions' to the person I want to be able to edit that one column, so it is secure to them only.

Would that linked sheet need to be in its own workspace, or could it be set up in the same workspace as the source sheet?

Will my plan work?

Best Answer