Formulas with look up fields

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.



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.


This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.