Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to count unique values in a Lookup Field?

Topic Labels: Formulas
444 0
Showing results for 
Search instead for 
Did you mean: 

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