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.
Edit option to colloborators
Hi,
I am new user to Smartsheet. Would like to know whether I can create a filtered Report with selective columns and then send to colloborators for editing. I understand that to achieve report editing, need to give complete share to the sheet ?
I want to restrict users to use only the rows and columns that are permited to use.
Thanks in advance.
Regards,
jay
Comments
-
Jay,
Depending on your use case, you may want to create separate Reports for each user.
Build the "Who?" portion in the Report Builder with each user.
You can also set the columns visible in the Report Builder.
And then you'll Share the Report with each individual user.
Hope that helps.
Craig
-
Thanks for the support
-
Thank you.
-
Hi Craig
I have assigned user called "jayk@gmail.com" in "WHO". Then I have logged in as Jayk@gmail.com from my mobile, but unable to see the records.
I gave full sharing to the sheet, then the filtered report is coming correctly.
Please help.
Regards,
Jay
-
Jay,
Share the Report and the Sheet. If the person is not a licensed user to the Sheet, then they won't be able to see the data.
Craig
-
Craig, that is not entirely correct... If you share a sheet with a user - regardless of if they are licensed or non licensed - they will have access to all the data in the sheet.
Jay, to answer you question - in order to see and edit the data in a report, they will need to be shared to the underlying sheet which will give them access to the data in that sheet.
The only open to give users editor access to a subset of a sheet is to use Update Request which can be set to include specific rows and columns. These expire after each use but can be set to send on a recurring basis.
-
All,
Jay shared the Sheet and the Report with me.
Here's some screen shots to go over the problems.
Which are:1. Not reporting on the correct column2. The column is not the correct type3. And likely the sheet is not shared to the users wanting to see the data (see Travis' comments above)So on to the details.The criteria (Who?) is looking at the Assigned To column, but there is another column where the Technician's name is entered.Lastly, there is a work-around here that I had not considered before.By having a "dummy" email (corporate or gmail) where someone has gone ahead with the process of getting a real account with that address, then everyone could log in using that VERY non-secure email address and see a Report that was using the AND condition for their names. You'd need to build a report for each, but you have to do that anyway.Feature Request: Report on "Me" as the criteria.So, Sally opens up the Sally Task Report by using the dummy email account and she sees her tasks without being shared to the sheet - of course the dummy email is and as soon as someone figures that out they can access the system. As I said, a VERY non-secure solution but I can see a VERY non-secure usage for it.NOT RECOMMENDED.Craig -
Oh, and yes Travis. Got me again.
Craig
-
Thanks for the detailed narration. I will recheck and confirm to you.
Thanks once again.
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