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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives