Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

hide certain columns per user

Options
Dan L.
Dan L.
edited 12/09/19 in Archived 2017 Posts

Basically: I want to hide certain columns for specific users.

In detail: I have 7 users shared to an affiliate sheet. This sheet contains the assets needed for marketing as well as rev share and money exchange. I want my graphic team to update the status of graphic assets but I don't want them to see the rev share columns. I also want my marketing team to see all the columns at a glance instead of having to link to a separate rev share sheet.

Is it possible to hide certain columns based on the user? 

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    I would look into creating reports. Even though they have to be shared into the original sheet as editors, you drive all your stakeholders to reports which can aggregate the data and only show those fields that you want them to see. 

    Here is more on creating reports: 

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Unfortunately, the primary concern does not appear to be ease of use but rather security and privacy. In that case, the Report function is only an inconvenience for the user that may want to see such data, not protection of the data from unwanted eyes.

    Depending on how often the rows are added / removed (not just modified), there are ways using cell linking, automation tools like Zapier (www.zapier.com), or other third party tools like AppSheet (www.appsheet.com) to keep data in separate locations (within Smartsheet or even in Excel or Google Sheets in the cloud) synchronized but separate.

    Unfortunately, there is not yet a way to do this natively within Smartsheet.

    Craig

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Hopefully, one day, they will add the ability to share and update reports without being shared on the sheet. :| It would be incredibly useful. Please submit a product enhancement request to add your vote to ours. 

This discussion has been closed.