Concat - remove dash if optional field left blank I am trying to remove dashes if an optional field is not filled out. Here is my current formula:CONCAT({DE:Region - Requesting Business Area},"-",{DE:Primary Requesting Business Area},"-", {DE:Secondary Business Focus},"-",RIGHT(YEAR({entryDate}),2),"-",{DE:Rally Feature Number},"-",{DE:TruBrand Family}) The first and third fields are optional (Region Requesting Business Area and Secondary Business Area) so I would like to remove the "-" if those fields are blank. I've tried to use the If IsBlank formula a few different ways and have not been successful. Can anyone help? ty! Here's my last attempt: IF(ISBLANK({DE:Region - Requesting Business Area}," ","-",IF(ISBLANK({DE:Primary Requesting Business Area}," ","-",IF(ISBLANK({DE:Secondary Business Focus}," ","-",CONCAT({DE:Region - Requesting Business Area},"-",{DE:Primary Requesting Business Area},"-", {DE:Secondary Business Focus},"-",RIGHT(YEAR({entryDate}),2),"-",{DE:Rally F