How to retrieve the name mentioned the most in a list (look up field)

I have a look up field that contains a list of companies’ names. I want to get the most mentioned company in that list.

More details:
I have three tables:

  • Tenders
  • Entities
  • Companies

Tenders table has a linked record from both entities and companies.
From the entities table I created a look up table that retrieves the companies column. I’d like to get the name of the company that was mentioned the most.

The idea is to answer the following question: Which company gets the most tenders of each entity?

regards,
Motlaq

I would just do it from the companies table. Create a field of type “count”, and then sort or group by that field.

Thanks for the reply but this isn’t the right approach.

The approach that I think would work but do know how to do it on Airtable is:
List the companies on a field > count the occurence of each company (still a list) > get the name of the company with the highest number.

Unfortunately that’s not possible in a formula field. It can be done via a script, though. Depending on how frequently you want to update this bit of data, you could perhaps use a scheduled automation to run the script.

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