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 ...

Yes please very important for our org as well.

There are instances where we have deactivated a user and they have a new user profile. If we delete the deactivated user the history for that person gets erased with the profile. We would like the ability to clean up these instances by being able to merge user history of the deactivated account to...