Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
It would be very useful to lock a single cell.
I see it's been asked many times on the community but I did not find anyone submitted it as an idea
If you lock a column, only admins and owner can edit it.
I know we have automation to lock a row, but if its possible to lock a column after a cell value has been populated would be a great feature…esp for cells that should not be changed once its been updated.
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
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
A use case for the solution I am currently working on would be to allow users to enter new data into the first X columns in a new row, but once the final column has been entered I would ideally be able to lock those columns for the row with a formula. I can use forms to enter data, but the number one complaint I get about that is the time it takes to enter the data compared to being able to copy and paste in a template. Dynamic view is unfortunately limited by the same constraints as the forms as far as I can tell.
Sign in to comment or add your vote.
