Skip to main content

How do you create a comma separated list from checkboxes?

  • August 3, 2023
  • 1 reply
  • 8 views
X
Forum|alt.badge.img+1

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.

 

1 reply

pressGO_design
Forum|alt.badge.img+21
  • pressGO_design
  • Brainy
  • 253 replies
  • August 3, 2023
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.


Terms & ConditionsAccessibility statement