Thank you both for your suggestions. I think I'm stuck with a CONCAT and trailing |||| for instances where there is no GL Code entered. As I would need it to show all the GL codes used in that forms submission. I was trying to rid myself of the | with the if statement so it would only return IF ther...

Hello All, I am trying to complete a formula where a calculation will only CONCAT fields if there is data to CONCAT. CONCAT(IF(custom field called Role 1 has data,CONCAT(Role 1 GL Code," | ",)," ", IF(custom field called Role 2 has data,CONCAT(Role 2 GL Code," | ",)," ", IF(custom field called Role ...