The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Is my syntax wrong in IF formula for Lookup column?
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})
)
Accepted Solutions
