Formula to populate parent from one column in another?


I'm am combining a bunch of sheets in one and then reporting off of that. For reference, the application is resource tracking, so lots of project plans that I'm combining in one so I can report at a "portfolio level".

Is there a formula that will do this? I want the parent text from the Task Name column to populate in the Sub-project column for any child rows so when I copy the row to the PMO sheet we can report on project and sub-project levels.

YES I've looked at Resource Management Classic, doesn't meet our needs, can't get the Resource Management view anywhere but from SS Resource Views (can't put it on a dashboard for example) and we need to share THAT view.

YES we are evaluating Resource Management but for what we are looking to do, it's like pounding a nail with a sledgehammer.

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar


Best Answer