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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!