Pull data from other sheets located in other workspaces
I need to gather data from project sheets located in the project workspace to the portfolio update sheet in another workspace. I was hoping I could do that automatically. Control Center is not available at this time.
I can set it up within the workspace for the project dashboard. I need to get the data over to the portfolio workspace for the portfolio dashboard.
A simple solution would be the send a weekly request for updates to the PM and have them enter the data, but that creates redundant work that I want to avoid. Any ideas how I could gather the data automatically?
Thanks in advance,
Susan
Best Answers
-
Hi @Susan Hildebrant ,
you may use a portfolio summary sheet with all the columns you need, where each project is represented by one row.
A new project needs to be cell linked once it starts and then data will be kept up to date all the time.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Hi Stefan,
Thanks for your quick response. I can have our administrator add the links when she does the provisioning. It seems to be the simplest way. Thanks for your help.
This Community is the BEST!!! I have gotten so much help quickly and it is really appreciated. 🤓
-
Hi Andree,
This is an interesting solution. Not sure it will work in this circumstance as the sheet that requires the specific fields also needs to be edited manually for other fields.
I appreciate the input. I have saved the link for future reference.
Thanks,
Susan
-
Happy to help!
If you need to edit, it won't work, unfortunately, so Stefan's method is best for this use-case.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Susan Hildebrant ,
you may use a portfolio summary sheet with all the columns you need, where each project is represented by one row.
A new project needs to be cell linked once it starts and then data will be kept up to date all the time.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Hi Stefan,
Thanks for your quick response. I can have our administrator add the links when she does the provisioning. It seems to be the simplest way. Thanks for your help.
This Community is the BEST!!! I have gotten so much help quickly and it is really appreciated. 🤓
-
To add to Stefan's excellent advice.
Another solution could be to use the Sheet Summary and the Sheet Summary Report feature.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
This is an interesting solution. Not sure it will work in this circumstance as the sheet that requires the specific fields also needs to be edited manually for other fields.
I appreciate the input. I have saved the link for future reference.
Thanks,
Susan
-
Happy to help!
If you need to edit, it won't work, unfortunately, so Stefan's method is best for this use-case.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!