Email Changes to Name

When I enter in my email address, it changes to a name format. I am trying to Index/Match it to another sheet and it doesn't recognize it unless it stays in the email format. How can I set up to not convert?
Best Answer
-
The email address is changing because the column type is "Contact List". You have two choices:
- Change the "Corrective Action Step Owner 1" to a "text/number" field by right clicking on the header and going to "Edit Column Properties"
- Add a column to the right of "Corrective Action Step Owner 1" and make this a "text/number" field.
The Contact List field has some special functionality you may want to keep, if so choose #2 above. If you don't want the new column showing email to show up you can always hide it. A hidden column will still work with filters on reports or queries.
I hope this helps.
-Edward
Answers
-
The email address is changing because the column type is "Contact List". You have two choices:
- Change the "Corrective Action Step Owner 1" to a "text/number" field by right clicking on the header and going to "Edit Column Properties"
- Add a column to the right of "Corrective Action Step Owner 1" and make this a "text/number" field.
The Contact List field has some special functionality you may want to keep, if so choose #2 above. If you don't want the new column showing email to show up you can always hide it. A hidden column will still work with filters on reports or queries.
I hope this helps.
-Edward
-
Thank you. I was able to use option 2 and it seems to be working.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives