How to count unique values in a Lookup Field?

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.