Lock single cell

Kristy Vu

I agree. The ability to lock at the cell level is especially helpful when coordinating across multiple teams. There's less inadvertently changing data, which I find is the most common issue when a sheet is shared across the organization.

stkatch

Not to be confused with locking a row or column. For sheets that are shared for editing rights but you want to lock a cell after certain criteria is reached - thereby eliminating any possible changes. Especially in fairly large data sheets where an activity log or cell histories would be an astronomical task to ensure that Validated Data has not changed. Example; CFO has approved a value or date and has editing rights but once it is approved, want the value cell to lock. But the column needs to stay unlocked for other editors.

Howard R

This feature has been requested multiple times since 2017. Please look into implementing

mcullen

I saw some older posts for this but nothing recent. I think it would be helpful to have the ability to lock a single cell from editing.

SML

+1 for this feature

tcleaning

That would be a great feature! Some work arounds would include the already mentioned sheet summary- lock that cell. Another would be to Copy the row to a sheet not accessible by those who might change it. You could also use dynamic view to display, but not allow editing of the cell. You can also set automation rules to lock and unlock rows based on certain triggers.

While that doesn't lock a single cell, there are some workarounds to hopefully get close in the meantime.

Cheers!

Megan_ClavieParker

In my use case, I need to be able to lock single cells after they are populated through an Update Request, because if they change again they'll trigger duplicates of subsequent workflows that should only happen once. I don't think I can lock the whole row because users need to be able to update other fields in later steps.