How to refer to Parent of another column

SandyA

Hi - I need to create a summary column for all the children rows, that draws on various parent columns and builds them into 1 string.

eg Builder, PO, Site Supervisor, Mobile

This would be displayed on each child row, for each of my tasks so that it can be easily displayed in reports.

Thank you.

Andrée Starå

@SandyA

Try something like this.

=PARENT(Builder@row) + " - " + PARENT([Site Supervisor]@row) + " - " + 
PARENT([Mobile Phone]@row)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @SandyA

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SandyA

Hi @Andrée Starå

Parent row contains columns (shown as [xx] below), which I wish to join together in a new column, and populate throughout the child rows.

so that it displays as [Builder] & "-" & [Site Supervisor] & " -" & [Mobile Phone] in a new column that is converted to a column formula.

Each of the [columns] fields only contains values in the parent row.

I could copy the values down from parent to child in each column, but I was wondering if there was another way of referring to the parent value in another column without duplicating all of the data.

Andrée Starå

@SandyA

Try something like this.

=PARENT(Builder@row) + " - " + PARENT([Site Supervisor]@row) + " - " + 
PARENT([Mobile Phone]@row)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SandyA

@Andrée Starå thank you that worked perfectly!

Andrée Starå

@SandyA

Excellent!

You're more than welcome!