Parent Function

Options
ukuri
ukuri
edited 12/09/19 in Smartsheet Basics

I am using a helper column to show the "parent" of each row. However, the problem is that some rows are indented more than once, so they have multiple "parents". Currently, the system shows the most immediate "parent" row( for example AM#1 Shows "Account manager"). However, I wish to show the highest level parent in the hierarchy ( for example, AM#1 to show "Key Hires")

Capture_4.JPG

Comments