Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Remove duplicates from my Assigned To column?

When I assigned a task to my colleague, I noticed she was listed in the Assigned To column twice. One of the options just has her email address and the other one has both her name and her email address. How can I remove one of these?
Comments
-
Jeff Tolbert Employee
Hi Allie!
If you assign a task to a contact from your Smartsheet Contact List and the name doesn’t match what the user has listed on their Smartsheet account, this will create duplicate values for that person in the sheet's contact list drop-down menu.
You can either have the user login to their Smartsheet account, click Account > Personal Settings, and add a first and last name to their account that matches what you have in your contact list.
Or you could also consider re-assigning all of the rows to the name/email address on the user's account. First, click the “Sharing” tab at the bottom of the sheet. The name/email address you see here is what the user set up on their account. Re-assign all rows to this name and the duplicate value will disappear from the drop-down list.
-
Allie ✭
I had her set up a name on her Smartsheet account and that fixed it! Thank you!
Categories
I hope you're well and safe!<\/p>
I can't see any rows in your screenshot that should be colored differently. Parent rows can't be changed.<\/p>
Can you share more screenshots with the conditional formatting options used on a few child rows?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help. <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>