Output combined column name values from checkboxes.

jambla

Hi,

I have a number of checkboxes, if they are checked I want to output the column value in another cell.

I understand we can't reference the column values but I am able to do this:

=IF([Red]1, "Red")

This will return a single value if the checkbox is true.

When I try something like this:

=IF([Red]1, "Red", IF([Green]1, "Green"))

I can only output a single value, in this case Red or Green.

I would like to be able to output like my image above.

Thanks for the help!

Andrée Starå

Hi,

Try this.

I'd recommend adding the column names in the first row (or where it makes sense) on the sheet, and that would make it easier to use the formula below.

=JOIN(COLLECT($Red$1:$Blue$1; Red@row:Blue@row; @cell = 1); "/")    

The same version but with the below changes for your and others convenience.    

=JOIN(COLLECT($Red$1:$Blue$1, Red@row:Blue@row, @cell = 1), "/")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting