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), “”))

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!