Report top level ancestor for each level of daughter

TCJ

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!

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

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!