Distinct Formula


Thank you in advance for any assistance you can provide me.

I have 2 columns (Assignee, Total Tickets) - Assignee is comprised of a list of names (most are formatted as email but a few are stated names). I need to create a formula that will provide me a listing of unique names (thus removing the duplicates). For Total Tickets, I am sure that is a second formula that I will tackle to provide the corresponding number of tickets assigned to them.

I have been trying to use Distinct in the formula but I keep getting UNPARSEABLE or a count of 1 instead of names -- I am unsure of where I am going wrong.

This is what I have tried ---

=IF(COUNTIF(Assignee$1:Assignee@row,=[Assignee]@row)1, 1, 0

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!