Help

Re: Formula Help Needed: Multiple Checkboxes into one text field

Solved
Jump to Solution
1656 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashley_Eidbo
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Screen Shot 2022-09-19 at 5.40.58 PM

1 Solution

Accepted Solutions

I forgot a comma on one line. Try again.

See Solution in Thread

6 Replies 6

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.
image

In any case, post your current formula and I can try to help you remove the commas.

Ashley_Eidbo
5 - Automation Enthusiast
5 - Automation Enthusiast

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”)
Screen Shot 2022-09-19 at 8.54.02 PM

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.

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, ")
  ),
  ", $",
  ""
)

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.

I forgot a comma on one line. Try again.

it worked! thank you SO much. have been trying to figure this out for awhile.