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.
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi @Trish Dillon
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
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
