Restriction to add to cells only

Options

Is it possible to permit free users to edit cells but not to be able to add rows or columns?

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 02/22/22 Answer ✓
    Options

    Hi @Vinton Douglas

    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 02/22/22 Answer ✓
    Options

    Hi @Vinton Douglas

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!