Create a string in one cell based on checkbox selection

[rizzo93]

My spreadsheet has three checkboxes that users can select from. I want to create a string in one cell based on the checkboxes they select. I need to do this using a formula--no VBA.

If they select this:

Then the string I want should look like this:

SOC2;ISO​

Multiple values should be separated by semicolons but should not end with one.

I've tried using IF formulas with no success. Suggestions please?

 

[KOKOSEK]

Each of these assign into particular cell behind (like A1, B1, C1). Then in result cell You should be able to easy sort this out.
Like below with CHOOSE:

=CHOOSE($A$1+1,"","SOC2;")&CHOOSE($B$1+1,"","HITRUST;")&CHOOSE($C$1+1,"","ISO")

 

[dreid1011]

Building off of kokosek's formula, this way you can select only 1 checkbox and not have a trailing ";".

=TEXTJOIN(";",,CHOOSE($A$2+1,"","SOC2"),CHOOSE($B$2+1,"","HITRUST"),CHOOSE($C$2+1,"","ISO"))

 

[mikerickson]

=SUBSTITUTE(TRIM(IF(A1,"SOC2","")&" "&IF(B1,"HITRUST","")&" "&IF(C1,"ISO","")), " ", "; ")

 

[rizzo93]

It took me a little bit to figure out how it worked, but I finally got it! Thanks everyone!

 

[dreid1011]

You're welcome, and happy to help.

 

[Peter_SSs]

Looks like you could also use

=MID(IF(A2,";SOC2","")&IF(B2,";HITRUST","")&IF(C2,";ISO",""),2,16)