Restriction to add to cells only
Is it possible to permit free users to edit cells but not to be able to add rows or columns?
Best Answer
-
You can restrict the creation of columns by only providing your shared collaborators with Editor access to the sheet, however this will allow them to create new rows.
An alternative is the Commenter permission which will only allow users to attach files or add comments to the row, without adding new rows, columns, or cell data.
This Help Article has a chart that explains what collaborators can do on different permission levels: Permissions on sheets, reports, or workspaces
You could also send individual rows out to specific email addresses to ask for updates. This would enable free users (who don't even need to have Smartsheet) to edit cell contents of one row, without seeing the underlying sheet or adding any rows or columns. See: Update Requests
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
You can restrict the creation of columns by only providing your shared collaborators with Editor access to the sheet, however this will allow them to create new rows.
An alternative is the Commenter permission which will only allow users to attach files or add comments to the row, without adding new rows, columns, or cell data.
This Help Article has a chart that explains what collaborators can do on different permission levels: Permissions on sheets, reports, or workspaces
You could also send individual rows out to specific email addresses to ask for updates. This would enable free users (who don't even need to have Smartsheet) to edit cell contents of one row, without seeing the underlying sheet or adding any rows or columns. See: Update Requests
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 479 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!