Changing display name causing dups?

Regina S

We have a custom built Smartsheet solution. When it was built the person's full name was used in various places in the solution, used in formula's and automations. What we have discovered now that we are using the solution, is when a person goes in and updates their display name in their settings, from Robert to Bob or adds/removes a middle initial, the system no longer recognizes they are the same person, even though the email address never changes. This is now causing problems, as we see Robert and Bob in a row or report, and have to adjust our reports to account for both names - this is hard to do as we don't know who changed their name and to what. Has anyone else had this problem, and if so, what did you do to solve?

kowal

hi @Regina S,

Seems someone who built the solution created it the way that the name from the Contact List is used statically not dynamically. It's difficult to tell what is the reason without seeing the system and how it was built.

Here I created sample for you to show that test 1 and test2 can have the same email adres despite they are 2 different users.

Regina S

Thanks @kowal - yes, I believe that is what is happening, do you know how I would be able to fix this? Our contacts are added manually to Smartsheet (if that is helpful at all to know). Thanks!

kowal

well I would try to import all the contacts through CSV file and tell all the colleagues what could be the consequence of changing the names so nobody would touch it :)