Report top level ancestor for each level of daughter

Hello. I have a list of tasks, each one placed under a project functions (Regulator, Clinical Ops, etc.)

I have made the task listed under a function a daughter, and in some cases there are multiple levels. An example is Clinical Ops - United States - Lab Start up. Lab Start up is a daughter of United State which is a daughter of Clinical Ops.

Is there a way, in a separate column, to return the highest level parent. For both Lab Start up and for United States, the highest level parent would be Clinical Ops. I would like to be able to turn this into a column formula

The goal is to use to enable reports based on the highest level parent.

Thank you for your help!

Find more posts tagged with

Accepted answers

Darren Mullen

@TCJ Hi! Yes, you can do this. I think this video will show you what you need to know.

https://www.youtube.com/watch?v=8GhBTDUOKkY

All comments

Darren Mullen

@TCJ Hi! Yes, you can do this. I think this video will show you what you need to know.

https://www.youtube.com/watch?v=8GhBTDUOKkY

TCJ

Hello Darren, Thank you so much, this did help solve my challenge!

Darren Mullen

@TCJ you're welcome!

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.