Is it possible to get the reference of the First Parent ?

I would like to extract the sub-parts whose biggest Parent is called Media communications.

Is there any function that allow us to extract the name of the biggest parent instead of the closer one ?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!