IBM Notes - Formula Language - Column Value from Checkbox Field

Question

I have a checkbox field. I want to display the values from that field in a column view. The values in the field are names such as John Doe Smith. When there are multiple values in the checkbox they are displayed in an awkward manner. For instance

John Doe Smith,Jane Doe Smith,Mary Doe Smith

I want to remove the commas and replace them with a "comma space" so they are more readable. The above example should look like this

John Doe Smith, Jane Doe Smith, Mary Doe Smith

I've tried using @Replace and @ReplaceSubstring along with @Text, @Explode, @Implode, etc but I can't get the desired result.

Does anyone have a suggestion?

Robin-

Answer 1

@Implode is the way to go. Your column formula is then:

@Implode(YourCheckBoxField; ", ")

Answer 2

In the column properties, in the second tab, select the option "Show multiple values in separate entries" Sorry for the English, I'm using google translate