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!

Register your interest and get Smartsheet Guru's 7 tips.

Register your interest for the Smartsheet Guru Elite and get our 7 Smartsheet tips!

You have Successfully Subscribed!