Admin Control Vs Editor Can Share
Good afternoon,
We have a workspace with ONE master sheet that it is crucial no one but the Admins are able to make changes to.
We also have other sheets that feed that sheet with automated actions that require users to be able to delete rows and add rows etc
However we just try to restrict those users to "Editor - Can Share" in the workpspace but now it wont let them Edit the sheet rows that feed the master sheet and it says they need Admin access to do it.
How do we fix this problem ?
Best Answer
-
Hi @BESP10
Is it possible that the data these Editors are attempting to change are in Locked columns or rows? Editors are able to create and edit rows in Smartsheet, as long as they are not locked. This Help Center article has a helpful table that will outline what your Editors can and cannot do: Sharing Permission Levels on Sheets
As an alternative, you could store the Master sheet in a different location. You can still have all of the sheets feeding into this Master located in the Workspace, while keeping this one sheet outside of the Workspace so that they do not have any Editor or Admin permission to it. Does that make sense, and would that work for you?
Cheers!
Genevieve
Answers
-
Hi @BESP10
Is it possible that the data these Editors are attempting to change are in Locked columns or rows? Editors are able to create and edit rows in Smartsheet, as long as they are not locked. This Help Center article has a helpful table that will outline what your Editors can and cannot do: Sharing Permission Levels on Sheets
As an alternative, you could store the Master sheet in a different location. You can still have all of the sheets feeding into this Master located in the Workspace, while keeping this one sheet outside of the Workspace so that they do not have any Editor or Admin permission to it. Does that make sense, and would that work for you?
Cheers!
Genevieve
-
-
No problem! I'm glad we could figure it out. 🙂
-
Hello,
Another question that I think is related to this topic. I am using WorkApps and there is a report that is set up that does not have the filter features visible in WorkApps directly. When the user goes to the report directly the filter and sort functions are available but they still cannot sort. Two of the twelve fields in the report are locked on the Sheet. Do they ALL need to be unlocked for the Sort function to work. Also, why are these features not available in the WorkApp?
Thank you,
Marlayna
-
This actually has to do with how Reports are built, versus what columns are locked.
Only Admins or Owners of the Report can adjust the "Report Builder", which are all the options on that top row (what sheets are used, the filter, the grouping, the sort, etc).
See: Sharing Permission Levels under the Report heading.
Since Workapps can only give Editor permissions through the Workapp view, these options are not available. You will need to go to the actual item inside the Smartsheet application in order to adjust how it's created.
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives