View formattingSharePoint Online

RYG Status

A status column is evaluated to provide colors corresponding to status. This format uses the values Red, Yellow, Green, and Amber but you could easily extend this to fit your own color-coded system by adding or removing nested conditions.

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([$CurrentStatus] == 'Red', 'ms-bgColor-red', if([$CurrentStatus] == 'Green', 'ms-bgColor-green', if([$CurrentStatus] == 'Yellow', 'ms-bgColor-yellow', if([$CurrentStatus] == 'Amber', 'ms-bgColor-orangeLighter', '')))) + ' 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

screenshot of the sample

View requirements

The format expects the following field:

Field	Type
Status	Single line of text / Choice

To use a lookup column instead, replace all occurences of [$internalfieldname] with [$internalfieldname.lookupValue].

Sample

Solution	Author(s)
ryg-status-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.