Using dynamic form to update sheets

Can a Smartsheet Viewer make changes to an existing sheet through a form by submitting data via the form which is linked to the sheet, even if they only have "Viewer" permissions, allowing them to update specific fields within the sheet without needing full edit access to the entire sheet; essentially, the form acts as a controlled interface for data entry. 

Tags:

Answers

  • ChristianFinke
    ChristianFinke ✭✭✭✭✭

    Hi @Richard.D.Williams,

    Yes, a Smartsheet Viewer can submit data via a form linked to a sheet. Forms bypass sheet permissions, allowing anyone with the link to submit data. This is useful for controlled data entry without granting full edit access.

    To update existing rows, you can set up automations or workflows triggered by form submissions.

    If you'd like help setting this up, let us know!

    CHRISTIAN FINKE

    cfinke@digitalradius.com

    Schedule a Meeting