Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How do you create a comma separated list from checkboxes?

Topic Labels: Formulas
583 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.