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.
Lock a Field
I have a field with a formula in it and I want to be able to lock it so only owners and admins can edit.
i cant lock the row as details have to be changed by editors in other fields in the row.
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Comments
-
J
You also have the ability to lock the column, perhaps that will work.
Dan
-
Thanks Dan, but I only want to lock the parent rows not the whole column
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
J Tech - there isnt a way to lock single cells, only entire rows or columns. I will submit an enhancement request for the ability to lock single cells.
-
Another vote for this please.
-
I'm surprised this functionality (ability to lock formulas but still allow users to edit cells) has not been released yet. Have there not been enough votes?
The solution I keep hearing is to lock the column or row...but doing that does NOT allow users to add their entries. Surely we can get more folks to vote for this. Or maybe there's an existing solution and I'm not finding it?
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