
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 02, 2020 09:15 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 02, 2020 02:12 PM
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}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 02, 2020 02:12 PM
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}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 02, 2020 02:27 PM
Brilliant! Thank you, it worked.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 02, 2020 02:29 PM
Could you please mark my reply above as the solution?
