Duplicate Unique Client ID


I have created a Smart Sheet to help employees track when they connect with clients. I'd like to create a unique client ID for each client to help track different times the same client has been connected with. However, I cannot figure out how to alter the auto-number column to correlate the clients name with the same client ID for the second or third contact in different rows on the same sheet. Is there a way to format the auto-number function such that these clients name triggers duplicate the same client ID?

Best Answer