Share only filtered info
Still new to Smartsheets and could use some help defining a shared view of a larger sheet.
I have a sheet that I would like to share only specific data with a person (view mode) and I set a column titled as EU and place an X in the row for data that I want to share with another person. I then created a filter for the EU cases and saved my sheet.
Now I want to share this with the person. I've gone into File / Share / and used EDIT button toward the bottom. Under Filter, I thought there would register the filter that I had just created "EU cases", but there is nothing.
Am I doing this right?
First screen shot you can see file / share .... and you can also see that I have the filter for EU Cases.
The next pic shows the Edit button options.
What am I missing? It seems to be right in front of me, but I'm not seeing it.
TIA to all!
Answers
-
So, in this scenario, instead of creating a "filter" in the sheet, what you most likely want to do is to create a Report, and then share the Report with the user.
Also - once you have the Report created, instead of sharing the link directly to the Report, you should "Publish" the Report and then share the "published link" with the User. When you do this, then you do not need to give the User access to your Sheet.
When you create the Report, you will specify the Sheet that the rows are coming from, and you will be able to setup the "filter" using the Report Builder, so that you select only those rows that you want that User to see.
You can read more about Reports here:
Hope this helps.
Regards,
Bee
Business Manager, AcuWorkflow
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