Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formulas with look up fields

Topic Labels: Formulas
Solved
Jump to Solution
288 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I am using a look up field in a formula (on another field).

The formula is just CONCATENATING the look up field, but I receive an #ERROR! when I try this. Is there a way around this.

Cheers!

Sam

1 Solution

Accepted Solutions

Hey Jonathan,

You’re correct, I have added an ARRAYJOIN to each lookup field referenced in the formula and it all worked out.

Thanks!

See Solution in Thread

2 Replies 2

Hi @Sam_Horlock - a lookup field actually returns an array of values or objects, so I think this could be the issue here. However, when I tried this with simple, single lookup values - numbers of strings - Airtable deals with it. Can you give some examples of the data you’re looking up and the formula you are using?

Hey Jonathan,

You’re correct, I have added an ARRAYJOIN to each lookup field referenced in the formula and it all worked out.

Thanks!