Extract selected data from sheet (without using report)
Hi Smartsheet community!
I have the following problem:
I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to extract an shipment overview from this complete list of items that only includes the necessary data to notify the receiver. The obvious approach would be a report but that means that the receiver would need to have access to the Smartsheet with the complete list - which I can't grant them because there is lots of data included that I may not share.
Attached you see two screenshots that show 1) test data that show the structure of the complete list and 2) the target structure of the test data that I would like to have in a separate Smartsheet.
I've tried to use a pivot sheet, vlookup function... but failed. Has anybody had a similar problem before and was able to solve it? Your support would be highly appreciated.
Comments
-
Hi Gabriele,
You might consider creating a report and publishing it; you can provide a publish link to the receiver without having to share the underlying source sheets with them. Details on publishing are available here: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items#publishreports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!