Formula to populate parent from one column in another?

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.

Find more posts tagged with

Formulas

Accepted answers

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))

All comments

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 !

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.