Review-Due Flag

The Review-Due Flag highlights documents that are past their review or expiry date, so nothing slips through unreviewed in a controlled library. It is built with a standard SharePoint document library and a small piece of column-formatting JSON applied to a review-date column. Files past due show a red flag, files due soon show an amber one, and everything else shows a tidy date.

Author

SharePoint Maven

Built with

• SharePoint

Features

Date and Time Column, JSON

Category

Formatting

Want one like this?

Talk to Greg

Overview

• Flags documents that are past their review or expiry date in red
• Files due within two weeks show an amber heads-up
• Files reviewed and current show a tidy neutral date
• Compares the review date to today automatically, so it stays current
• Applied as column-formatting JSON, so it changes nothing about the files
• Works on any review or expiry date column

Common Use Cases

• Policy and procedure review cycles
• Compliance and certification documents
• Contracts with renewal dates
• Safety and quality records
• Standard operating procedures
• Any library with review or expiry dates

Details

• Design Pattern: File & Library Display
• Format Scope: Column

Required Columns

Prerequisites

1. Open your document library and add a Date column named Review Date.
2. Because the JSON is applied at the column level, the Review Date column can use any name you want.

How to Apply JSON code

1. On the Review Date column, open the column header menu, choose Column settings, then Format this column.
2. Switch to Advanced mode.
3. Paste the JSON below and click Save.

JSON Code

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "span",
  "style": {
    "display": "inline-flex",
    "align-items": "center",
    "width": "170px",
    "box-sizing": "border-box",
    "padding": "1px 7px",
    "border-radius": "6px",
    "line-height": "20px",
    "white-space": "nowrap",
    "background-color": "=if(@currentField == '', 'transparent', if(Number(Date(@currentField)) < Number(Date(@now)), '#fdeceb', if(Number(Date(@currentField)) < Number(addDays(Date(@now), 14)), '#fdf3d6', '#f3f2f1')))"
  },
  "children": [
    {
      "elmType": "span",
      "attributes": {
        "iconName": "=if(@currentField == '', 'Calendar', if(Number(Date(@currentField)) < Number(Date(@now)), 'Warning', 'Calendar'))"
      },
      "style": {
        "font-size": "11px",
        "margin-right": "5px",
        "line-height": "20px",
        "color": "=if(@currentField == '', '#8a8886', if(Number(Date(@currentField)) < Number(Date(@now)), '#a4262c', if(Number(Date(@currentField)) < Number(addDays(Date(@now), 14)), '#7a5c00', '#605e5c')))"
      }
    },
    {
      "elmType": "span",
      "style": {
        "font-size": "12px",
        "font-weight": "600",
        "line-height": "20px",
        "white-space": "nowrap",
        "overflow": "hidden",
        "text-overflow": "ellipsis",
        "color": "=if(@currentField == '', '#8a8886', if(Number(Date(@currentField)) < Number(Date(@now)), '#a4262c', if(Number(Date(@currentField)) < Number(addDays(Date(@now), 14)), '#7a5c00', '#605e5c')))"
      },
      "txtContent": "=if(@currentField == '', 'No date', if(Number(Date(@currentField)) < Number(Date(@now)), 'Review due - ' + toLocaleDateString(@currentField), 'Review ' + toLocaleDateString(@currentField)))"
    }
  ]
}

Common Questions About the Review-Due Flag