Color Status Indicator

Verified 2016

Grade Example

Create Numerical Column named Score

Create Calculated Column named Grade

=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))

Create Calculated Column named Color … hidden in final view

=IF([Score]>89,"Green",IF([Score]>79,"Green", IF([Score]>69,"Yellow",IF([Score]>59,"Red","Red"))))

Create Calculated Column named Status … note must be numeric

=CONCATENATE("<div style=",CHAR(34),"height:20px;width:20px;border-radius:3px;background-color:",[Color],CHAR(34),"> </div>")

UPDATE: border-radius:100% changes it to circle

My 'Title' field returns the following results:

ie: Gold.png

I want to remove '.png' and just leave the word 'Gold'

=REPLACE([Title],SEARCH(".png",[Title]),"4","")

References

Calender