Skip to main content
Solved

Formulas with look up fields

  • October 26, 2020
  • 2 replies
  • 36 views
S

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

Best answer by Sam_Horlock

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!

2 replies

JonathanBowen
Forum|alt.badge.img+18

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?

S
  • Sam_Horlock
  • Author
  • New Participant
  • Answer
  • October 29, 2020

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!

Terms & ConditionsAccessibility statement