Column level permissions

Since there aren't column level permissions, I tried Dynamic view, which would work great if we could utilize proofing with Dynamic View, which is not possible.

I have columns a specific group of users should NOT be able to edit on my sheet. However , I utilize proofs. Does anyone have a creative solution to not allow the group of users to NOT be able to edit the specific columns on the sheet?

Best Answer

  • Darren Mullen
    Darren Mullen Community Champion
    Answer ✓

    @pamorpan

    If you lock those columns, does that stop other editors from editing them that need to edit them?

    If that's the case… I could see having to use update requests for some users to edit the column data… but that's not very user friendly.

    I'm wondering if you have WorkApps… maybe there is a way to control permissions that way for certain groups of users to be able to do what they need to do. Would require maybe creating specific reports for groups that need to edit certain data.

Answers