Editable Report with Shared Sheet that's Hidden/Locked

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 Watson
    Neil Watson ✭✭✭✭✭✭
    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.