[ElMiko]

I have three custom columns that are Yes/No columns (let's call them "#cola", "#colb", and "#colc"). I would like to create a fourth column that displays 8 values, ideally with each text value as its own color (as in a "Text, but with a fixed set of permitted values" column):
"ColA" (if only #cola's value is "Yes"),
"ColA, ColB" (if only #cola and #colb values are "Yes"),
"ColA, ColB, ColC" (if all three columns have "Yes" values),
"ColA, ColC" (if only #cola and #colc values are "Yes"),
"ColB, ColC" (if only #colb and #colc values are "Yes"),
"ColB" (if only #colb's value is "Yes"),
"ColC" (if only #colc's value is "Yes"), and finally
simply blank (if all values are either "No" or "Blank")

Anyone know how this would be possible, and what the syntax would be?