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

Only show the first value in the lookup field

Topic Labels: Formulas
1058 1
Showing results for 
Search instead for 
Did you mean: 


In my base, one table has 2 records each. Currnetly, i do a lookup and it shows me both records. I only want the first to show up because it just doubles the name twice. How can I make it so that when i lookup from that table, only the first (or last) record shows vs having both.

1 Reply 1

Try using a rollup instead of a lookup, and use this formula.