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.
View access only to a "set of rows" ?
Comments
-
Hi George
Try using a combination of Update Requests on selected rows for editor and Reports that are issued as View Only to show your collaborators a "through the letter box" view of just the data that is appropriate to them and not all the rest.
Hope that helps RichardR
-
George,
The reporting method is an easy way that you dont have to update or create as much as you would with other methods. If the user is view only on one sheet and is editor on another sheet. The report will only allow them to view those rows that are view only and make changes to rows that are editor level rows. Also note that if you have the person listed as the assigned to person for that row then you can be very specific to the person and have a tool that each person can access that shows them the rows that they are responsible for. It is live data and every time it is opened it is the most current list.
-
To clarify what Jeremy is saying, the report can be set to only show certain rows but in order to see the rows in the report, you have to be shared to the underlying sheets (which gives the user access to all the data in that sheet). If view only access is sufficient then you could build a report, publish it, then share the published report (the user will not need to be shared to the underlying sheets, but it is a read only view)
-
Thanks. I will explore your suggestions for my requirement. -George
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