Editing rights only for certain cells

I’m in charge of renting out pieces of our inventory, and I want my employees to be able to edit certain cells in the records (i.e. - General Remarks, Date Checked Out, Date Checked In), but not other cells (i.e. Manufacturer, ID #, Location). Any help?


Currently, the access right will be applied to whole sheet instead of specific fields. Hence, from your description, I would suggest creating a multiple version.

With multiple version, you may create new sheet with the same dataset. Then, in the new version, please configure other cells as read-only and then grant your employees the “Admin” access right in the new version so that they’ll be able to edit record. (Please remember to turn off their access right in the original version.)

1 Like