I have such a list as per screenshot.

I need to create another view, where first column "Risk Category" will show only unique values (so only 3 items in this case: "Legal risk, "Not meet delivery expectations" and "Organizational risk").

Second column should summarize "Risk Score" values per Category (e.g. "Legal risk" - 8)

And another question. Does anyone know the formula to setup the traffic lights depending on the number range? I need "green" for <2, "yellow" 3< x <5, and "red" for > 6.

Now I'm using this validation formula depending on the selected status:

="<DIV><IMG src='/_layouts/images/"&IF(Status="low","kpipeppers-0",IF(OR(Status="medium"),"kpipeppers-1","kpipeppers-2"))&".gif'/></DIV>"

enter image description here


1 Answer 1

  1. View: You can take a look here as to how to create view

Create a standard view and then for Columns select [Risk Category] and [Risk Score], for Group By, select [Risk Category] and then for Totals select Sum for [Risk Score]

The output should look like this.

enter image description here

2. Formula

You can try the below and let me know.

=IF([Risk Score]<=2,"Green",IF(AND([Risk Score]>=3,[Risk Score]<=5),"Yellow","Red"))

enter image description here

  • Thank you so much! Very helpful answer. I implemented both and it worked. Just one question: is there a way to have a selective view without "Group by" option? I mean, without having those Group lines with sum, but having just this outcome as normal list entry? Dec 9, 2020 at 14:52
  • With [All items] view without [Group By], you can see data in a table. But, when you need [Sum], this is what you would get. Only options for [Group By] available are Collapsed and Expanded. Please mark the question as answered if it provided the answer you were looking for. Dec 9, 2020 at 15:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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