Skip to main content

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.

 

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.

Reply