Assigned to // Contact List
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.