Assigned to // Contact List

Hi all,

I have an equipment tracker sheet that has an Assigned To column set as Contact List.

I came to realize that regardless this sheet is not shared with them, they are able to change/edit/modify the cells of this tracker sheet.

I don't want anybody to edit those cells except the ones that are already in the shared list with edit rights.

Is there a way to avoid this? Otherwise I'll change column properties from contact list to normal, but if I do that, my automation will not work, as there is an automation that sends weekly reports to the asset owners (assigned to//contact list).

Thank you for the support.

Answers