How do I concatenate contact names from different sheets?
How do I add a contact name from a sheet to a cell in another sheet that has already other names?
For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell?
Thanks!
Best Answer
-
Hi @User251
I hope you're well and safe!
To add to Christian's excellent advice/answer.
Unfortunately, it's not possible now to combine multiple contacts with a formula, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
This is for if you have a column of names and want distinct ones.
=JOIN(DISTINCT({Contact (Sheet1)}), " & ")
If this isn't the answer can you share an image? It's hard to follow a text explanation.
-
Thank you @Christian Graf for your reply.
Here is a screenshot of what I mean: I have 2 columns with contacts in Sheet 1 below. I need the contacts columns in sheet 1 to be separate because each column is used for a different purpose.
I want to be able to add the 3 contacts in one column in the second sheet below. I want to make sure that when my contacts in sheet 1 change, they automatically change in sheet 2.
Thank you.
-
Hi @User251
I hope you're well and safe!
To add to Christian's excellent advice/answer.
Unfortunately, it's not possible now to combine multiple contacts with a formula, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you @Andrée Starå . That was helpful. I will submit an enhancement request. I think adding the feature will be very helpful.
-
@Christian Graf . The formula you suggested works very well with columns that have any type other than Contact List. I get the error "#INVALID DATA TYPE" when I use it with 2 contact list columns. I submitted a request for improvement to the Smartshee team.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!