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
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
