How do I populate the highest parent level data into another cell?
I'm using the '=PARENT([Primary Column]@row)' formula, but it's populating data from the parent row, even if the parent row is a child of another parent. I need to populate in a separate cell data from the highest level parent row.
In the example below, is there a formula that would populate Primary Column row 1 data, "Main Parent 1" into Column2 rows 2-7, so that "Main Parent 1" is populated in rows 2-7? Then, I could use that same formula to populate "Main Parent 2" in rows 9-14.
Help Article Resources
Check out the Formula Handbook template!