Formula to populate parent from one column in another?

Andrea Zenner

Hello,

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.

Mike TV

@Andrea Zenner

Like this?

If so, here's your formula which you can set as a column formula and forget it:

=IF(PARENT([Task Name]@row) = "Workday", "", PARENT([Task Name]@row))

Mike TV

@Andrea Zenner

Like this?

If so, here's your formula which you can set as a column formula and forget it:

=IF(PARENT([Task Name]@row) = "Workday", "", PARENT([Task Name]@row))

Andrea Zenner

Perfect! Thank you so much @Mike TV !