Output combined column name values from checkboxes.
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:
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!
Help Article Resources
Check out the Formula Handbook template!