Pull out most looked up / rolled up item

Topic Labels: Formulas
552 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi there,

I’m facing a challenge with a lookup / rollup field. I will share a link to an example base I quickly threw together, feel free to check it out to better understand my challenge. Keep in mind that this is a very simplified version of my original base.

Skjermbilde 2022-01-28 kl. 14.10.11

I have a lookup field which lives in a table of drivers which gives me cars used for different trips. If a driver uses a BMW X3 on 3 trips, the lookup field shows “BMW X3” 3 times. If that same driver uses a Tesla Model 3 for 5 trips, the lookup field would contain BMW X3 3 times and Tesla Model 3 5 times. So far so good.

Now, what I want to pull out is simply “Tesla Model 3”, because that was used the most times. If one driver has used two/three cars the same amount of times, I would like to pull out both/all.

I’m not sure if it matters but in my base there will never be more than those 3 cars to select from. Also, it is not possible to use more than one car for a trip.

Does anyone have any tips and tricks to overcome this?

0 Replies 0