Only Unique Contacts Formula

Gianni

I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert automations.

KPH

Hi @Gianni

I do not believe you can combine contacts from multiple contact columns into another column as anything other than text. I did find this feature request that you could add your voice to:

https://community.smartsheet.com/discussion/97466/combine-contacts-from-multiple-columns-into-a-single-cell/p1