Pulling selective data from a smartsheet and put it into columns of another smartsheet
So I have two smartsheets
- Portfolio Sheet
- Project plan
In the portfolio sheet, I have the row 1. It has Columns StartDate and EndDate in that row. In the portfolio sheet, on that same row there is a Column called "Project Plan" that has a hyperlink to the actual project plan. Once that link is created in that column, I want smart sheet to go out and grab the StartDate and EndDate out of the project plan and bring it back to the portfolio sheet and update that row's StartDate and EndDate columns automatically. I know in the portfolio sheet I can link individual Cells back and forth but I don't want to have to do that each time. Is that doable and if so, how can it be done.
Answers
-
There are two ways I know of to pull individual project data to a portfolio-level sheet or report.
1 Use the Control Center's blueprint summary sheet.
2 Use Sheet Summary Report.
The link below has a video that will give you an idea.
If the "Portfolio Sheet" can be a report, I recommend the second, as the core product includes the feature. If the "Portfolio sheet" needs to be a sheet, you can use the Control Center, but it is a premium app.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!