Skip to main content

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

 

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… ))

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" )

 

 

Reply


Terms & Conditions