Combining Multiple Columns into One in a sheet: Help Needed

System

This discussion was created from comments split from: Auto copy info from one cell to another..

Not so formula savvy

I tried to use this but I am clearly missing something?

In my scenario I need all data from 3 separate columns (Requestor Name, Item Description and Vendor) to paste into a 4th column (Topic).

Column 1 Name: Requestor Name

Column 2 Name: Item Description

Column 3 Name: Vendor

Column 4 Name: Topic

Is this possible?

Andrée Starå

https://community.smartsheet.com/discussion/comment/441052#Comment_441052

Hi,

I hope you're well and safe!

Try something like this.

=JOIN([Requestor Name]@row:Topic@row, CHAR(10))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Not so formula savvy

When I plug it into the "Topic" Column, I get a #Circular Reference message? 😪

Andrée Starå

https://community.smartsheet.com/discussion/comment/441097#Comment_441097

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Not so formula savvy

Here is the best screen shot I could do due to confidential data. I took a snipit of 2 of the columns in reference that I need the data copied over to the "Topic" Column..if that made sense?..I'm not even sure its possible?

so in th

Smartsheet Copy sample.PNG

e screenshot, I need the "Topic" Column to read "Jason Request to replace"…

Andrée Starå

https://community.smartsheet.com/discussion/comment/441099#Comment_441099

Thanks!

I misunderstood, so try this instead.

=[Requestor Name]@row + CHAR(10) + [Item Description]@row + CHAR(10) + Vendor@row + CHAR(10)

Did it work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Not so formula savvy

It worked!!!!…Yes….thank you so much…I am such a happy camper…you are the best!🤩

Andrée Starå

https://community.smartsheet.com/discussion/comment/441128#Comment_441128

Excellent!

Thanks for the kind words, and you're more than welcome!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!