Skip to main content
Solved

New to AirTable, what am I doing wrong?

  • September 5, 2023
  • 2 replies
  • 36 views
M
Forum|alt.badge.img+3

Hello,
Hope you guys can help me. I have a "Edition" field that contains three options: Extended, Standard and 360 Edition. The concatenate formula works however when adding the IF statement for the 360 Edition I get " Invalid formula." 

What am I doing wrong here?

 

CONCATENATE({Order ID} & " " & Initials & " " &"Vol II") IF({Edition} = "360 Edition",BLANK())

 

Thanks

 

Best answer by pressGO_design

if what you’re trying to achieve is that the field is populated by the Concatenation when it’s Extended or Standard and is blank when it’s 360 Edition, then it’s 

IF(Edition = “360 Edition”, “”, CONCATENATE( ….insert the concatenate here… ))

2 replies

pressGO_design
Forum|alt.badge.img+21

if what you’re trying to achieve is that the field is populated by the Concatenation when it’s Extended or Standard and is blank when it’s 360 Edition, then it’s 

IF(Edition = “360 Edition”, “”, CONCATENATE( ….insert the concatenate here… ))

M
Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • September 7, 2023

Hello,
just to clarify.
CONCATENATE designed to be used like:  CONCATENATE( "AAA", "BBB", "CCC")
to get the same result, you can use  "AAA" & "BBB" & "CCC"
of course, CONCATENATE("AAA" & "BBB" & "CCC") will work also, but you are using concatenation twice.

also, in Airtable you can use  IF(statement, value_if_true) , which returns empty string when false
the word BLANK usually  not needed and often produces error in formula

so, you can also write in that way (not sure, didn't test)

 

IF({Edition} != "360 Edition" , {Order ID} & " " & Initials & " " & "Vol II" )

 

 
pressGO_design
Terms & ConditionsAccessibility statement