Consolidating Finanical data from Projects to 1 report / Sheet
Hi Everyone, hope someone can help.
I have a requirement to pull financial data out of each project that has a separate folder - there are about 100 of them. But I wonder if there is a way to automate this so I don't have to keep going in folder by folder to bring in new projects.
The end goal is to put it all into PowerBI as the amount of data is growing and will get start to make problems if we don't deal with it.
Anybody have this issue before? Any direction would be appreciated.
Answers
-
Are all of the project folders in the same workspace and have similar naming conventions for the sheets within? If so, you can reference the entire workspace with a report and create a filter based on the sheet name to only pull rows from sheets that contain (for example) "Financial Data".
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives