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), “”))
Delivered instantly to your inbox
Consider Smartsheet Guru’s eBook: Smartsheet User Guide for Accelerated Learning
https://youtu.be/-xprxcxxvdE I ran into an issue with Tableau bringing in data properly from Smartsheet when I had a...
https://youtu.be/a0BnrRwm_Bg This video shows a simple example of how to pull in a value from one sheet into another...
https://youtu.be/-MKvEnaB0Ck This video shows you how to count the occurrence of a specific contact in a multi contact...
Join the mailing list and get your copy of my 7 Smartsheet tips!
0 Comments