Help

Formulas with look up fields

Topic Labels: Formulas
Solved
Jump to Solution
866 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Horlock
4 - Data Explorer
4 - Data Explorer

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!