I'm trying to figure out how to return the name of a child's Parent.
Example:
Parent 1
Parent 2
In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function that returns this fuction?