How to count unique values in a Lookup Field?

Topic Labels: Formulas
680 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, so I’ve seen this question here and there on the community but for the life of me I can’t quite figure out how to do this - would appreciate any help!

What’s happening here is: This is my Findings Table. Each Finding is made up of several Quotes, and the Quotes are by different Participants.

What I’ve done

  • Link Findings to my Quotes table.
  • Look up Participants from Quotes, for each findings.

What I want to do

  • Count the unique number of Participants under the Lookup Field: Participant Source. (see the table below, my current formula is wrong and returns a count of 1)


I would like to Participant column to remain clickable as well, so roll-up isn’t an option for me. Would appreciate some advice on how I can do this easily, thank you so much!

0 Replies 0