Sharing a sheet | specific columns for access

11/13/20
Accepted

We are using the API feature and have shared a sheet with one of our vendors. They have asked if I can share the sheet that has been created with more members of their team, but they only want the new members to be able to access and update 2 of the columns on the sheet. Is it possible to share the entire sheet with people and set it up so they can only update certain columns?


Thanks in advance

Best Answer

Answers

  • Thanks Michele, that is kind of what I was thinking as well. Is there a way to only lock certain columns for certain individuals or would the column lock be global?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Shane Cornwell

    To add to Michelle's excellent advice/answer.


    A solution that would be perfect for this use-case is the premium add-on, Dynamic View.

    Is that an option?

    More info: 

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.