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!