asked on

Help with calculated field in sharepoint

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?

GeorgeGergues

You can add the calculated field to be
([DB_RTG001]+[DB_RTG002]+......+[DB_RTG020] )/20

Make sure you use 0 decimal points as your number value.

Best of luck

Matt Pinkston

ASKER

but the DB_RTG### fields equal either (Blue, Green, Yellow, Red or Grey)

GeorgeGergues

You might want to investigate some Javascript in content query webpart

first you might want to contact all the colors in a single string . then parse and count the encounter of "Blue" , Green ...

Also you can get the values in colors.

This article should give you some ideas

http://www.orbitone.com/en/blog/archive/2010/10/25/calendar-colour-coding-in-sharepoint.aspx

I am sorry I cannot go beyond that point.

Best of luck

Matt Pinkston

ASKER

looking for a way using IF in the calc field to do the addition like if DB_rt1001 = "blue" + 4, if DB_rt001 = "green" +3 so on...

Matt Pinkston

ASKER

still looking for a solution, I am not proficient with if statements in a calculated SP field but pretty sure this can be done.

ASKER CERTIFIED SOLUTION

Rafael I

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial