Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Sam_Horlock
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Sam_Horlock - profile
Sam_Horlock
4 - Data Explorer
since
Oct 26, 2020
Nov 29, 2022
User Statistics
2
Posts
1
Solutions
1
Kudos given
0
Kudos received
User Activity
Posts
Replies
Formulas with look up fields
Oct 26, 2020
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
Re: Formulas with look up fields
Oct 29, 2020
Hey Jonathan, You’re correct, I have added an ARRAYJOIN to each lookup field referenced in the formula and it all worked out. Thanks!
Kudos given to
User
Count
kuovonne
1
View all
