Help

Using Lookup Value in Formula

Topic Labels: Formulas
Solved
Jump to Solution
1483 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Swichkow
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to use data from a lookup field in a formula and keep getting #ERROR!.

The formula (below) works with a plain text field created to test, but not the lookup field.

IF({CITIZEN SLACKIDS}=BLANK(),’’,

‘<@’ & SUBSTITUTE(VALUE({CITIZEN SLACKIDS}),’, ', ‘>, <@’) & ‘>’)

I’ve tried wrapping the lookup field in VALUE () to no avail.

Screen Shot 2021-01-18 at 12.37.19 PM

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Hmmm… that’s a bit tricky, because those commas don’t really exist in your lookup field. Your lookup field is an array that Airtable is visually separating with commas.

I’m sure there are probably several different ways to solve this dilemma, but here’s one way that you can do it:

In your OTHER table (not this table), create a formula field which is this:

"<@" & CITIZEN SLACKIDS & ">"

Then, back in THIS table, change your lookup field to lookup that formula field instead.

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

Hmmm… that’s a bit tricky, because those commas don’t really exist in your lookup field. Your lookup field is an array that Airtable is visually separating with commas.

I’m sure there are probably several different ways to solve this dilemma, but here’s one way that you can do it:

In your OTHER table (not this table), create a formula field which is this:

"<@" & CITIZEN SLACKIDS & ">"

Then, back in THIS table, change your lookup field to lookup that formula field instead.

Thank you, Scott!

Your lookup field is an array that Airtable is visually separating with commas.

SUPER helpful to know, for this and other bits.

Created the formula in the other table as recommended and got the desired result (below). It’s a bit clunky by a necessity I now understand much better. Thank you!

Screen Shot 2021-01-19 at 11.39.08 AM Screen Shot 2021-01-19 at 11.40.45 AM Screen Shot 2021-01-19 at 11.40.53 AM

Fantastic! Glad I could help! :slightly_smiling_face: