Counting individuals supported by specific customer removing repeats



I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals may be supporting the customer. How do I calculate the unique number of individuals who support a single customer. The individual column is based on a dropdown list.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!