Skip to main content

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

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?

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!

Reply


Terms & Conditions