Calculated value concatenated when value Not Blank

Copper Contributor

Help please. I have columns ITEM1, ITEM2, ITEM3. If the ITEMs columns are not blank each ITEM will have a corresponding PART (PART1, PART2, PART3) and a SN (SN1, SN2, SN3). All are text columns. I am attempting to join the text only if the ITEM columns contains a value.  SHIPMENT CONTENTS column if where I'd like the concatenated value. I have tried everything I can think of.

=CONCATENATE(IF(ISNOTBLANK([Item1],[Item1],", ",[Part1],", ",[SN1]),IF(ISNOTBLANK([Item2]),[Item2],", ",[Part2],", ",[SN2]))


=IF(Item1<>"",CONCATENATE(Item1,", ",Part1,", ",SN1),""), If(Item2<>"",CONCATENATE("Item1","Part1","SN1"),""))


0 Replies