Editable Report with Shared Sheet that's Hidden/Locked

11/30/21
Accepted

Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself?


Thanks in advance!

Best Answer

  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    @Ashley Pierce since a report is a view of a sheet when you are editing the report, you are actually editing the underlying data in the sheet itself. So locking columns is the only way to avoid the underlying sheet properties from being changed by editors.

Answers

  • Edward SpencerEdward Spencer ✭✭✭✭

    That depends on what you don't want them to alter. I find the link below to be helpful and refer to it often, this is shows the permissions and what each one allows and does not allow in detail.

    See if this helps you, if not post back.

  • Ashley PierceAshley Pierce ✭✭✭✭✭

    It seems like the users will have to have edit access to the sheet to edit the report. If you save the sheet in a different workspace, would they deter them from editing the sheet itself? Besides locking columns/auto locking rows, I'm trying to figure out the best way to design it to where users can edit the report, but not the master sheet.

  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    @Ashley Pierce since a report is a view of a sheet when you are editing the report, you are actually editing the underlying data in the sheet itself. So locking columns is the only way to avoid the underlying sheet properties from being changed by editors.

Sign In or Register to comment.