Smartsheet Guru Logo

Written By: darren

January 3, 2023

Parents, Ancestors and Smartsheet, Oh My!

This video gives a demonstration of using the ANCESTORS() and PARENT() functions to reference multiple levels of hierarchy. As promised in the video, here are the formulas:

Level column formula:

=COUNT(ANCESTORS()) + 1

Project – Task Group column formula:

=IF(Level@row = 3, INDEX(ANCESTORS([Task Name]@row), 1) + ” – ” + PARENT([Task Name]@row), IF(Level@row = 4, INDEX(ANCESTORS([Task Name]@row), 1) + ” – ” + INDEX(ANCESTORS([Task Name]@row), 2) + ” – ” + PARENT([Task Name]@row), “”))

Get My 7 Smartsheet Tips + Bonus!

Delivered instantly to your inbox 

Looking for Powerful Smarthseet Tips?

Consider Smartsheet Guru’s eBook: Smartsheet User Guide for Accelerated Learning

Smartsheet User Guide for Accelerated Learning Powerful Tips to Jump-Start Your Smartsheet Training eBook cover

You May Also Like…

0 Comments

Subscribe To the Smartsheet Guru newsletter

Join the mailing list and get your copy of my 7 Smartsheet tips!

You have Successfully Subscribed!

Get your Smartsheet Lead Tracker app tutorial

Join the mailing list and get your tutorial video!

You have Successfully Subscribed!