My =IF(Child@row="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example,
In the Parent Column, I want to combine =IF(Child@row="Name1", "Parent1"), OR =IF(Child@row="Name2", "Parent2"), OR =IF(Child@row="Name3", "Parent3"), etc.
I also want to add other functions like, =IF(Child@row="Name1", "Sibling1" in the Sibling@row ... Is this possible? If so, how can I combine these? I want one huge formula to copy down the column so the other columns are automatically filled out when I select the child.
Thanks in advance!