Filters for different users

hi

Im a new smartsheet user and need some help!

we have a sheet with a work schedule. There are address/information columns and then columns of dates for various contractors. 

We would like to give view only access to subcontractors but only want them to see their own columns. We want them to be able to access this information through the app. 

I tried a report but the viewer can see all the information as they have to be a viewer on the sheet as well as the report  we need a “live” system so doing a PDF report isn’t an option for us  

I’ve seen suggestions for using AppSheet but wouldn’t have a clue  how to do this!

thanks

paul

 

Comments

  • Hi Paul,

    There currently isn't a way to only share specific rows, columns, or individual cells in a sheet to specific people.

    With that being said, you might consider creating reports for your specific subcontractors—then publishing it and sending them the publish link.

    A couple of things to keep in mind when publishing a report:

    • Published reports are live
    • The published version of the report is read-only; your subcontractors won't be able to edit it from their end unless they're also shared to the report from Smartsheet

    More info on this is available in the help center: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items#publishreports