Countdown Badge

The Countdown Badge shows how many days are left until a date as a round, colored token that turns from green to amber to red as the deadline approaches and overdue. It is built with a standard Microsoft List and a small piece of column-formatting JSON applied to a date field. The JSON counts the days to the date and colors the coin by urgency, so what needs attention pops out of the list.

Author

SharePoint Maven

Built with

• Lists

Features

Date and Time Column, JSON, Single Line of Text Column

Category

Formatting

Want one like this?

Talk to Greg

Overview

• Shows the days left until a date as a round colored coin
• Turns green when far off, amber when near, and red when overdue
• Counts down automatically against the current day
• Urgency thresholds are set in the JSON and easy to change
• Makes the items needing attention pop out of a list
• Applied as column-formatting JSON on a date field, so it changes nothing about the underlying data

Common Use Cases

• Deadlines on a task or filing list
• Renewal or expiry dates
• SLA or response-due dates
• Contract or license end dates
• Event or launch dates
• Any date where the days remaining drive action

Details

• Design Pattern: Dates & Time
• Format Scope: Column

Required Columns

Prerequisites

1. Build a list with these columns before you paste the JSON.
2. Then populate the list with dates.
3. Because the JSON is applied at the column level, the Due column can use any name you want.
4. The near and overdue thresholds live in the JSON – change them to match how your team reads urgency.
5. It shows four separate states – overdue, 0 to 7 days, 8 to 30 days, and more than 30 days – and because it reads a date the result depends on your tenant time zone and time of day (test close to midnight).

How to Apply JSON code

1. On the Due 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": "div",
  "style": {
    "width": "100%",
    "display": "flex",
    "justify-content": "center",
    "align-items": "center",
    "padding-top": "4px",
    "padding-bottom": "4px",
    "box-sizing": "border-box"
  },
  "children": [
    {
      "elmType": "div",
      "style": {
        "width": "40px",
        "min-width": "40px",
        "max-width": "40px",
        "height": "40px",
        "min-height": "40px",
        "max-height": "40px",
        "border-radius": "50%",
        "display": "flex",
        "align-items": "center",
        "justify-content": "center",
        "text-align": "center",
        "box-sizing": "border-box",
        "font-size": "13px",
        "font-weight": "800",
        "color": "#ffffff",
        "background-color": "=if(@currentField == '', '#b8b8b8', if(((Number(Date(@currentField)) - Number(@now)) / 86400000) < 0, '#d92d20', if(((Number(Date(@currentField)) - Number(@now)) / 86400000) <= 7, '#f79009', if(((Number(Date(@currentField)) - Number(@now)) / 86400000) <= 30, '#12a866', '#067647'))))"
      },
      "txtContent": "=if(@currentField == '', '-', if(((Number(Date(@currentField)) - Number(@now)) / 86400000) < 0, if(indexOf(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), '.') < 0, ((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), substring(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), 0, indexOf(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), '.'))) + 'd', if(indexOf(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), '.') < 0, ((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), substring(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), 0, indexOf(((abs(((Number(Date(@currentField)) - Number(@now)) / 86400000))) + ''), '.'))) + 'd'))"
    }
  ]
}

Common Questions About the Countdown Badge