I currently have a Calculated column that produces a colored circle depending on another column.
=IF( ISERR(RIGHT(LEFT(Level,2),1)-1)
,""
,"<DIV style='font-weight:bold;
font-size:24px;
color:"
&CHOOSE( RIGHT(LEFT(Level,2),1)
,"blue ","green","yellow","orange","red")
&";'>•</DIV>"
)
I have an issue, when I open up my list item or go to filter my list, it comes up with "•"
This makes it hard for people to know what colors to filter for.
Instead of creating separate views for each color, is there I way I can edit the code in my calculated column to output text aswell as my colored Traffic light?
ie. Next to the red traffic light there's text displaying "Red", next to the blue one there's text displaying "Blue."