Concatenate Parent and Children Names

James Tucker

Hello All,

I am trying to get a column to concatenate the Parent and Child Names

For example, In my primary column I have

12345

AA

BB.

CC

In another column I would like it to Concatenate the names

12345

12345 AA

12345 BB

12345 CC

in excel it would be

=Concatenate(Parent & Child)

I tried

=(Parent() + Child())

Still no go.

Thanks for any thoughts or help

Andrée Starå

Hi James,

Try something like this.

=PARENT([Primary Column]@row) + " " + [Primary Column]@row

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

James Tucker

Still new to Smart Sheets so I might not know what I am talking about,

Is "@row" a variable that the formula uses, or am I declaring that row number when I write the formula.

I should have been more specific in my original post.

The Idea is that I could have one formula copied all the way down in the column that would automatically join the parent and child names. having to declare the parent row number in the formula would defeat the purpose of what I am trying to do.

Thank you for your help

Andrée Starå

@James Tucker

Happy to help!

@row is a Smartsheet function, so you don't have to think about row numbers. It will always reference the row it's on and the specified column.

My formula would show as below when you drag it down, and the Primary Column on the row is AA, BB, or CC.

Make sense?

Is that what you need?

12345 AA

12345 BB

12345 CC

More info:

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Nikki. A

Following up on this question, I am able to use the formula in a new column and get the results that I want but I don't want to have it in a new column.

Right now my structure is :

• Parent 1
• Child 1
• Child 2
• Parent 2
• Child 1
• Child 2

I want to use a formula on the same column without creating a new one to display

Parent 1

Child 1 | Parent 1

Child 2 | Parent 2

Parent 2

Child 2 | Parent 1

Child 2 | Parent 2

I can create a new column and then use the formula below to get the results I want, but I don't want to have to deal with yet a new column, in the old column, I want the children names to be displayed with the parent information

=[Task Name]@row + " | " + PARENT([Task Name]@row)

Thanks

Nikki. A

Many of the tasks have multiple parents, additionally, I'd want to pull in all the parents not just the one immediately above.

Nikki. A

@Andrée Starå Do you think you can help with my question?