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

Grégoire Cadet
Grégoire Cadet ✭
in Formulas and Functions

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 ?

=Parent(Example@row)

Tags:
· Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!