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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!