Combine individual Contact cells by formula
Hi,
I have 2 individual columns and they are with property "Contact". I would like to combine the contact values of these 2 columns and store them in the 3rd contact column, that means the 3rd column can store multiple contacts in the cells. Is there be a way to combine two individual contact cells into one cell with both contacts using a formula?
Thanks in advance.
Answers
-
Actually I submitted this case to Smartsheet support (case #: 05032421) but I haven't got any reply.
-
Hi @Ivan Tam
You can populate a multi-contact cell with another multi-contact cell in a one-to-one relationship, but it's not currently possible to bring in 2+ individual cells into one Contact cell as multiple values.
Please let the Product team know this is something you would find useful by filling in this form, here!
Thank you,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Ivan Tam , I know this response is months later, but it might help others too. I was just trying to figure out a way. This sort of worked: =[contact column 1]@row + ", " + [contact column 2]@row . Unfortunately, once combined, the cell doesn't recognize the emails as "contacts" within Smartsheet though. It simply shows a list of email addresses.
-
I know this is an old thread, but replying to @Genevieve P. , is there a way to grab every contact in a column then have them combined into a single cell so I can have that combined list appear on another sheet via sheet linking?
-
Hi @A.J.
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
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, Awesome, 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.
-
@Andrée Starå , I asked about this in 4 different places during Engage. You were right! Not possible currently.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!