View formattingSharePoint Online

Risk Score Indicator

A number column is evaluated against tiers of values to provide colors corresponding to score ranges.

Get this format View on GitHub

Shared by S Merchant
Updated Sep 9, 2018

Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Definition

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "additionalRowClass": "=if([$Score]>= 16, 'ms-bgColor-red', if([$Score] >= 12, 'ms-bgColor-orangeLighter', if([$Score] >= 8, 'ms-bgColor-yellow', 'ms-bgColor-green'))) + ' ms-fontColor-white'"
}

Schema compatibility review notes

This historical definition differs from the pinned Microsoft schema. This may indicate an unsupported pattern or a schema limitation. Check the original requirements and test in your tenant before use.

/additionalRowClass must be object

.definition[hidden] { display:block !important; } .variant-chooser,[data-copy] { display:none; }All definitions are shown below. Select the code manually or download the JSON file.

From the contributor

How to use this sample

Summary

A number column is evaluated against tiers of values to provide colors corresponding to score ranges.

screenshot of the sample

A number column is evaluated against tiers of values to provide colors corresponding to score ranges. This format provides 4 ranges:

Range	Color
value >= 16	Red
16 > value >= 12	OrangeLighter
12 > value >= 8	Yellow
value < 8	Green

You can easily adjust the values/colors to provide your own ranges. You can also add or remove nested conditions to increase or decrease the number of ranges needed.

View requirements

The format expects the following fields:

Field	Type
Score	Number

Sample

Solution	Author(s)
risk-score-rowclass.json	S Merchant

Version history

Version	Date	Comments
1.0	Septmeber 9, 2018	Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.