Auto create a contact based off 3 columns

Is it possible to create a contact column based off info from 3 other columns.
Customer First Name (colum1) , Customer last Name (column 2), Email Address (column 3) Created contact is column 4 (a contact column)
Answers
-
I just tested and it seems you can create a contact using a pretty simple formula so long as your @something.something is always the same.
I used my name in my sheet and it linked right up to my contact in the list, it seems so long as your emails are loaded it should be fine.
If you have other emails we might need to make some changes but this is a very basic setup, if it works cool if not let us know.
=[First Name]@row + "." + [Last name]@row + "@Email.org"
^I added a . because thats our email format but it depends what your format would be^
-
If you're trying to get a format like this: Bob Smith <bob.smith@gmail.com>, for example, you can use a formula to concatenate everything together in the contact column, but it will not resolve correctly to a contact. Your best bet is to just use the email address in the contact column.
Smartsheet Solutions Architect
www.adapture.com
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives