Concatenation + IF formulas

[EmA]

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!

[Kamille_Parks · Accepted solution]

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}

[EmA]

Kamille_Parks:

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

Brilliant! Thank you, it worked.

[Kamille_Parks]

Could you please mark my reply above as the solution?