Best Of

I love Smartsheet, but my biggest hesitancy in transferring some processes here are this exact issue. For large trackers that many people access, I really wish you could limit access to specific columns, rows, or cells to certain people. Google Sheets has had this for years

It would be great to lock a single cell, I'm working with others in sheets and when I have confirmed data I want to be able to lock it but sometimes I am waiting on them adding in other data so locking the row or column isn't an option

Hello Experts,

Currently, smart sheets providing options to lock rows or columns. However, we also need option to lock at cell level.

Sorry, but not understanding why this would be difficult to understand. Sheets that replicate what we used to do in Excel/Google Sheets have formulas that users might overwrite. It seems that formula cells should be locked to all but the Owner by default, and other cells by selection. Since the central idea of Smartsheet is collaboration, this is actually very surprising that a) we don't have that capability, b) Smartsheet would ask us to explain why it would be important. I hope this doesn't sound rude, it's just very curious. In Google sheets this is accomplished in 2 clicks.

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.

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!

+1 for this feature

I would like the ability to lock not an entire column or row, but just a single cell, and then unlock it when data is added to another cell. The solution could be implemented as a workflow.

Currently the only option we have is to lock the entire row. Sometimes, I want people to change a value and have that change other cells and lock the values in after a submittal or an update without locking them out of the main cell they need to change.

If this is implemented I would also like to see this option appear for locking automation as well!