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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 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!