Metadata sheet pulling data from 40 project plans into 1 dashboard?

Melitta King
Melitta King ✭✭✭✭
edited 10/05/20 in Formulas and Functions

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?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!