# Concatenation + IF formulas

Solved
623 3
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hello -

I’m having trouble with IF and CONCATENATION formulas

Here is what I’m trying to achieve:
Concatenate “SUB SKU” - “PRODUCT NAME”
If “SUB SKU” = Blank, concatenate “Parent SKU” - “PRODUCT NAME”

I tried it this way but it’s not working.

IF({SUB SKU}, CONCATENATE({Sub Sku},” – “,{Product Name}),IF({SUB SKU}=BLANK(),{Parent SKU},” – “,{Product Name})

Appreciate any help. Thanks!

1 Solution

Accepted Solutions
16 - Uranus

Since the last two parts of the output will be the same in either condition you could simplify you formula a bit:

`IF({Sub SKU}, {Sub SKU}, {Parent SKU}) & ' - ' & {Product Name}`

3 Replies 3
16 - Uranus

Since the last two parts of the output will be the same in either condition you could simplify you formula a bit:

`IF({Sub SKU}, {Sub SKU}, {Parent SKU}) & ' - ' & {Product Name}`

5 - Automation Enthusiast

Brilliant! Thank you, it worked.

16 - Uranus