1

I have a list with a column called Client Satisfaction which is a choice field with the following

1 2 3 4 5 6 7 8 9 10

I would like a calculated column to make any number between 1,2,3,4,5,6 red, 7 orange and 8,9,10 green

Here are some of the columns in the list, I would like the change the color of the Satisfaction number as stated above

enter image description here

What would the calculation be?

Thanks

  • where do you want this color code. is it the list view? – Hardik Kothari Nov 12 '14 at 14:55
  • Yes in the list view, I have updated my question with a screenshot, thanks – Matt Saunders Nov 12 '14 at 19:59
2

You need to use HTML calculate column for this, please have a look at:

HTML Calculated Column - Client Side Rendering

For SharePoint 2013, simplest way is to use Client-Side Rendering (JSLink property).. Please have a look at following samples:

Client-side rendering (JS Link) code samples

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.