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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives