Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: New to AirTable, what am I doing wrong?

Solved
Jump to Solution
590 0
cancel
Showing results for 
Search instead for 
Did you mean: 
maad
4 - Data Explorer
4 - Data Explorer

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

 

1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

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

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
10 - Mercury

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