Showing information from Smartsheet A in Smartsheet B
Hi there,
Is it possible to exactly show information from a source smartsheet to a destination smartsheet?
Scenario -
- I have two smartsheets with exactly the same column headers.
- One smartsheet is for the whole portfolio and displays a lot of information, currently information is copied into it from the second smartsheet which contains a specific subset of information.
Is there a way to automate this in smartsheet? It looks like you can link a row but if you add new information to the second smartsheet (lets say as an ident underneath an existing task) then this will not be reflected in the main smartsheet.
V Lookup isn't really what I want as that is more for specific field, I am effectively wanting to update smartsheet b and any changes are also automatically reflected in smartsheet a.
Answers
-
Have you looked into creating a row report?
-
I think what I need is an automation workflow (copy row to another sheet when a specific action takes place), I cant get it work at the moment but that seems to do what I need in principle
-
Ok. But why do you need it on another sheet as opposed to a row report?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives