Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 05, 2023 12:48 PM - edited Sep 05, 2023 01:16 PM
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
Solved! Go to Solution.
Sep 05, 2023 01:33 PM
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… ))
Sep 05, 2023 01:33 PM
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… ))
Sep 06, 2023 11:19 PM
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" )