Lock Columns to limit editing
It would be great if we could limit which columns in a sheet we will allow a user to edit.
Best Answer
-
I agree that it would be helpful to know more about what you're referring to - it is currently possible to Lock Columns and restrict editors from changing cell data in those columns. 🙂
Here's more information:
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Do you mean all users or a specific/dynamic set of users?
With one of my sheets, I only want the owner of the "item" (or line) to edit data. I would love to assign a single or multiple people by entering their contact names in one cell, which would then allow other cells to unlock for them. So even if someone fills in a form for a brand new item and adds their own name to that cell, then they will have the ability to edit that particular line item. Also include the ability to use the "created by" name as well.
This way I feel there is more direct control, right in the particular sheet, over who will have access to their own and to other's data (other than the admins).
That's only my particular use case that I can think of now. -
I agree that it would be helpful to know more about what you're referring to - it is currently possible to Lock Columns and restrict editors from changing cell data in those columns. 🙂
Here's more information:
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @spauliszyn and @Genevieve P.
Locking the columns absolutely worked for me! Thank you so much for the help!!
Cheryl
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives