I have a sharepoint list I am using to help rate things on a dashboard view. I have 20 fields that get a rating of either Blue, Green, Yellow, Red or Grey (Grey is not applicable). These fields are DB_RTG001 - DB_RTG020.
I want to have a field called RTG that is a calculate field which is the average of all. And then about field called COLOR which is the overall rating color.
I was thing that the Colors would have values:
Blue - 5
Green - 4
Yellow - 3
Red - 1
Grey - 0?
How would I set up the calculated field and then the color field?