Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Locking a Single Cell
Comments
-
Hello,
There currently isn't a way to lock a single cell in Smartsheet. What you might consider doing is creating a report for your other collaborators to work with. They can still edit data, but can't edit formulas in a report. More on creating reports here: https://help.smartsheet.com/articles/522214-creating-reports
-
Thank you Shaine!! Sad we can't lock single cells .. maybe one day
-
We are all waiting for it jstanley, trust me
-
I vote for this feature, too. Experiencing the same issue, and a report is not the answer in this case.
-
We would appreciate this feature too. Using the report work around doesn't quite work how want it to either.
-
This would be really great if this were possible. It would be a game changer...
-
Yep. Need it.
-
We need it please.
-
I also vote for this capability; the ability to lock cells independent from a column or row lock. PM methodologies based on the phase of the project require this type of capability.
-
-
add one vote.
-
Right solution is devolopping locking cell feature not to advise creating reports. Because it isn't not a pratical solution. +1 vote for this important feature.
Thanks
-
I have a bunch of formulas in the parent rows that I'd like to lock but there's one cell that I'd like to use for controlling the rest. (Type N/A in cell 2 & all the formulas change to N/A)
It's much easier to trust users not to break the formulas than to set everything up as a separate report but it would be great to be able to lock individual cells. In this particular case, just locking all formulas on the page would be useful. Even requiring a confirmation before editing formulas would be preferable.
I can see, from a UI perspective, why it's done this way. You can clearly see when a row is locked because of the icon on the left. There's no easy way to display the same information on individual cells and that wouldn't be wanted in most cases either.
Still, locking cells seems like an important feature to include. If the previous suggestions aren't feasible (lock/protect all formulas), another option might be a 'locked cell mode'. In normal mode, locked cells show no visual difference but cannot be edited. In 'locked cell mode', locked cells are highlighted, can temporarily be edited, and can be locked & unlocked. That would make things clear and easy for users, though probably not particularly easy on the back end.
There must be a solution for these use cases one way or another.
-
It seems to have been over a year and we still cannot lock single cells. I would like to add my vote to this request.
-
An important feature for me, too. some cells have formulas, others are open for data entry. I need to protect the formula cells from inadvertent data entry.
Would even help to be able to lock entire rows, but that doesn't seem to work even if I select the option to lock rows. I must be missing something obvious.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives