Editable Report with Shared Sheet that's Hidden/Locked

Ashley Pierce

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!

Neil Watson

@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.

Edward 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.

https://help.smartsheet.com/articles/1155182-sharing-permission-levels

See if this helps you, if not post back.

Ashley 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 Watson

@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.