Contact column created by formula keeps reverting to text
Hi Smartsheet Community.
I'm hoping that this is a setting or something simple I'm missing. I have an employee list of 1500+ employees that is being auto-updated by our IT team once a week. Currently the weekly info dump puts in the Name and Email address (along with a lot of other information that is useful, but not relevant here). I use this in a variety of VLOOKUPs.
I have set up the proper formula to combine Name with the email address (=Name@row + " <" + [Email Address]@row + ">").
So, here is my issue:
Every time I (or anyone with editor access) opens the sheet, the contact cells revert to the text version of the formula results (First Surname <[email protected]>). After every update, I have to go into the sheet and convert the column to text, and then back to Contact.
Is there any way to make the Contact format permanent, AND automatically apply to new employee entries?
Any assistance is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!