
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 03:41 PM
Hello,
I’m looking for help with a formula/script/automation. I have 5 fields that are checkboxes noting a user’s role. Some users have none checked, some have some, or even all. Also, these fields may be updated at any time by the user, so need something that updates automatically (both adding or removing a role).
I need another field that uses the title of the checkbox field (or text I provide), and puts them into one field. I’m struggling with adding commas, because they only need a comma if another role needs to show up behind the prior one.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 08:28 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 04:09 PM
Hi @Ashley_Eidbo,
Is there a reason that the options are checkboxes?
Why not a multiselect or link to another record. Then you would not need a formula at all.
In any case, post your current formula and I can try to help you remove the commas.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 06:55 PM
unfortunately I need to keep the checkboxes for some integrations that run off of it. I do, however, have some formula fields with the correct words showing. Those formulas are: IF({Curricular Lead}=1
,“Curricular Lead”)
The formula in the prior screenshot is coming from those: CONCATENATE({CL for HS},", “,{IL for HS},”, “,{SL for HS},”, “,{IA for HS},”, ",{TC for HS})
I’m assuming I need many IFs for this to work, but everything I try gives me an error.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 07:43 PM
REGEX_REPLACE(
CONCATENATE(
IF({Curricular Lead, "Curricular Lead, "),
IF({Implementation Lead},"Implementation Lead, "),
IF({School Leader},"School Leader, "),
IF({Inquiry Advocate},"Inquiry Advocate, "),
IF({Tech Contact}, "Tech Contact, ")
),
", $",
""
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 08:15 PM
I copied and pasted this, but I cannot get it to work (keep getting an error and cannot save). I’m not familiar with the dollar sign in this context, but wondering if that’s the issue? Any other ideas?
Thank you so much for your help.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 19, 2022 08:28 PM
I forgot a comma on one line. Try again.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 20, 2022 05:05 AM
it worked! thank you SO much. have been trying to figure this out for awhile.
