I'd like help figuring out a way to pull data from individual project sheets into a master sheet.
Here is my challenge. This is what the project sheet looks like.
It is a single sheet per project that has various stages and ranking data that is summarized in the top few rows. The end date is also something I need to pull, but that will be easier once I get the other question answered.
This sheet only has the project name in the title at the moment and what I need to pull is the Cool Score and Risk Score in rows 5-6 in the score column and the Stage which is in the Primary column shown in yellow here.
The master sheet where I want to pull this information looks like this:
Based on the Project name column, how can I pull the Cool factor and Risk factor from each of the separate project sheets shown above.
I appreciate any help!
Help Article Resources
Check out the Formula Handbook template!