Only Unique Contacts Formula


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!