Help

Is my syntax wrong in IF formula for Lookup column?

Topic Labels: Formulas
Solved
Jump to Solution
658 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Emma_Garwood
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there Airtable community!

I’m having trouble with an IF statement. I have a lookup column with two values, Turned or H/L. If the value is Turned, I want my formula to add the values in each of the shoe sizes listed. I’m getting an ERROR every time I try it though. Is it because the value (H/L) is a lookup value? The formula saves correctly, but the resulting value is #ERROR!

Screenshot attached too…

thanks for your help :slightly_smiling_face:

IF(
SEARCH(“H/L”, {Toe Puff}),
SUM({2},{2.5},{3},{3.5},{4},{4.5},{5},{5.5},{6},{6.5},{7},{7.5},{8},{8.5},{9},{9.5},{10},{10.5},{11},{11.5},{12},{12.5},{13},{14})
)

Screenshot 2021-06-11 at 11.26.15

1 Solution

Accepted Solutions
Emma_Garwood
5 - Automation Enthusiast
5 - Automation Enthusiast

Ah… thanks to @AlliAlosa on this thread

I added ARRAYJOIN and the searching of the lookup field worked. Nice!

See Solution in Thread

1 Reply 1
Emma_Garwood
5 - Automation Enthusiast
5 - Automation Enthusiast

Ah… thanks to @AlliAlosa on this thread

I added ARRAYJOIN and the searching of the lookup field worked. Nice!