Smartsheet Contact List column converted to Text column still does not show the email ID.
I am having trouble in retaining the email ID alone in the Smartsheet column. I tried the method but it is not working. (The objective for me is to develop Row Level Security on Power BI using the email ID. )
- Method 1: Created a new column "Email ID" and referenced it to the master column "Name". I set the column "Email ID" to text type. Initially it shows up like "John Doe <[email protected]>" but once i save and refresh the sheet, the value reverts back to the name "John Doe".
- Method 2: Although not a viable option since the email IDs that are going to be added to the column is going to be dynamic and not in my control. I tried to update the "My Contact List" and see if it works, but even this didn't help.
A few key points to be kept in mind:
- Preferably the solution needs to be dynamic with the assumption that we don't have control over the # of email ID.
- The email ID column has the option to multi-select.
Any solutions would be appreciated.