Metadata sheet pulling data from 40 project plans into 1 dashboard?
I am working with sheets, already created. There's 1 project plan and several sheet i.e. a RAID log and a Decision log that go along with each project. Then there is a metadata sheet (1 per project) that pulls info from the project plan and calculates it and then it gets displayed in a dashboard.
The lastest ask is a metadata sheet that pulls from all 40 project plans and displays into a dashboard similar to the project dashboards. I can't even imagine what the calculations are going to be like - is there a limit to the conditions that can be calculated?
Anyone have any experience with something similar?
Help Article Resources
Check out the Formula Handbook template!