How to pull the top parent to the row

S.Stone

I need a way to consistently pull the top-level parent to all rows below for our reports.

Here's an example:

In this case, all of the apples need to have "Alpha" on their row. Similarly, all of the variations of Ed, Edd, and Eddie, as well as Easy and Edison, need to have "Echo" on their row. So on and so forth.

Right now, I've got =PARENT([Primary Column]@row) to pull the first parent level, but how can I consistently pull only the top-level parent into one column?

Edit: I have added a helper column to designate the "1-Project" level that I need to pull to all of the children. I'll use this for conditional formatting, but it would be ideal of a formula could help me to pull whatever is in the Primary column next to the "1-Project" helper and then add that to all of the children below.

I think I'm almost there, but would still like some assistance if anyone can help me to wrap this up!

Thanks so much for any help!

Victoria_Indimar

Hi @S.Stone!

You can use the Ancestor function for this. https://help.smartsheet.com/function/ancestors

=INDEX(ANCESTORS([primary]@row),1))

Hope this helps!

Victoria_Indimar

Hi @S.Stone!

You can use the Ancestor function for this. https://help.smartsheet.com/function/ancestors

=INDEX(ANCESTORS([primary]@row),1))

Hope this helps!

S.Stone

@Victoria_Indimar Thank you!!!