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,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!