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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives