prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.
You can achieve the first permission setting by giving your users either View only or Commenter access to the sheet. Then you can provide them with a Form to insert new rows into the sheet, but be unable to edit them afterwards. I've personally done this where the Form is embedded on a Dashboard right next to a view of the sheet so they can see both at one time.
For the second permission setting, edit fields but not create rows, this can be achieved by either using the add-on Dynamic View, or a shared Report in a Workapp (depending on your plan type).
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now