Converting email from Text/number format to Contact List format
In a smartsheet, I have a Text/number field that has email in the format [email protected]. When I change the format from Text/Number to Contact List, it does not change to Contact list format as John Doe <[email protected]>, it leaves the name field blank and I have to add the name manually.
Is there anyway email in Text/number can be converted to Contact List format easily? These emails are of smartsheet licensed users.