Removing Duplicates from Contact List

I have a SmartSheet grid that has multiple Contact columns using type "Contact List".

There are duplicate contacts shown in User Contact List, which I am trying to clean up.

When I go to "Account, My SmartSheet Contacts", the functionality in that window seems to allow me to delete or edit "My Contacts". HOWEVER, when I go back to the supporting grid and refresh the browser, I do NOT see those modified contact entries.

Is there another Contact List for my grid that I cannot access? Why aren't updates to the name field showing in the grid after editing?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Because those are "your" contacts as opposed to Smartsheet contacts. You would need to edit the column properties.

Matt Henson

OK. So there are multiple (at least two?) Contact Lists? One "personal" and on "system" or "grid" or "workspace" specific?

How do I manage and "clean up" the non-personal Contact List? Where can I access that data for cleanup/correction?

Paul Newcome

In the column properties. If you double click on the column header, there should be a list of every name used in the column.

Matt Henson

That method worked for columns that had a few entries, but for columns having a larger number of entries, they weren't displayed. So, I was able to solve part of my issue, but not the majority of the changes that I'd like to make. Any other suggestions?

itsnotbroken

I have old email addresses in my Smartsheet contacts that keep coming up in construction schedules and other sheets. This is causing a TON of missed notifications and other errors.

The icon looks correct when looking at the sheet, but it's the old (dead) email address of the vendor. I have fixed this several times, but for some reason the bad address populates to other sheets.

I need to DELETE the entry everywhere. Period.

Is there any way to do this?

Amy Jacobson

I am seeing a similar problem. The Contact List column is not set to "restrict values" so one person using the sheet can add a new contact as they go, and often they only enter the email address. I would like them to show up by name, so I add a new contact that includes their name and email address. Now when I start to type their name, both options are there, and I would like to remove the ones that are only email addresses, but don't see a way to do that, as there is not a specific list of contacts in the column properties.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.