The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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!
