Implement a Visual Risk Indicator for Records (e.g., Grants and Engagements)
Introduce a visual indicator, similar to a stoplight system, to represent the risk level associated with records such as grants or other engagements. This would allow users to quickly assess the likelihood of success by viewing the associated risk level at a glance:
- Green – Low Risk
- Yellow – Medium Risk
- Red – High Risk
- Grey – No Value/Not Assessed
Key Features:
Display Locations: The indicator should be visible on the individual record, within list views, and be accessible for reporting purposes.
Data Representation: In addition to the color-coded indicator, the corresponding textual value (High, Medium, Low, or None) must also be retrievable for use in filters, logic, and reports.
Value Assignment:
- Risk levels can be set manually by users.
- Alternatively, the values can be determined automatically based on predefined criteria. For example:
A custom numeric field (e.g., "Risk Score") could be used.
If the score is between:
- 1–25%, set to Green (Low Risk)
- 26–50%, set to Yellow (Medium Risk)
- 51–100%, set to Red (High Risk)
- No value, set to Grey (Unassessed)
This would help support better risk assessment and decision-making across grant and engagement records.

-
Cecile LaBore commented
Risk of what?
-
Lisa Cullimore commented
This would be an excellent improvement - we categorise our projects using a custom field as a "Project Health Indicator" with the dropdown options of Green, Amber and Red. It would be great if this could also be colour coded in list views (this is possible for the project status field).