Admin Control Vs Editor Can Share

BESP10
BESP10 ✭✭✭✭✭✭

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

  • Genevieve P.
    Genevieve P. Employee Admin
    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

  • Genevieve P.
    Genevieve P. Employee Admin
    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

  • BESP10
    BESP10 ✭✭✭✭✭✭

    That was it


    The columns were locked!


    Thank you @Genevieve P

  • Genevieve P.
    Genevieve P. Employee Admin

    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

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Marlayna Sullivan

    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