Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How do you create a comma separated list from checkboxes?

Topic Labels: Formulas
745 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Xmarks
4 - Data Explorer
4 - Data Explorer

Hello All,

I'm trying to create a formula that will create a comma-separated list of headers from checked checkboxes.

As you can see below when I check one of these boxes I would like it to automatically populate the Achievement Rollup Field with the heading of that field and any others I check.

Xmarks_0-1691044661950.png

 

1 Reply 1
REGEX_REPLACE(
CONCATENATE(
IF({A}, "A, "),
IF({B}, "B, "),
IF({C}, "C, ")
),
", $",
""
)
but substitute your field names for A, B, C
 
Also crediting @kuovonne because this is a formula she shared a while back.