Skip to main content

Percentage Grid (Column JSON)

The Percentage Grid turns a percentage into a ten-by-ten block of squares that fill up as the value climbs, so completion reads like a tiny progress picture instead of a number. It is built with a standard Microsoft List and a small piece of column-formatting JSON applied to a number field. Each of the hundred squares lights up when the value passes its position, giving a crisp, chart-like read of how far along something is.
Author
SharePoint Maven
Built with
Features
JSON, Number Column, Single Line of Text Column
Category
Formatting

Want one like this?

Talk to Greg

Overview

  • Renders a percentage as a ten-by-ten grid of squares that fill as the value rises
  • Each square represents one percent, so the fill reads as a precise proportion
  • Filled and empty colors are set in the JSON and are easy to change to your brand
  • Reads any 0 to 100 value, so it works for completion, capacity, or coverage
  • The percent label sits beside the grid, so you get the picture and the exact figure
  • Applied as column-formatting JSON on a number field, so it changes nothing about the underlying data

Common Use Cases

  • Project or task completion on a tracker
  • Onboarding or training progress
  • Capacity or utilization on a resource list
  • Test or requirements coverage
  • Fundraising or quota attainment
  • Any 0 to 100 metric you want shown as a proportion

Details

  • Design Pattern: Metrics & Progress
  • Format Scope: Column

Required Columns

Display nameColumn typeInternal name
ProjectSingle line of text[Title]
CompleteNumber[Complete]

Prerequisites

  1. Build a list with these columns before you paste the JSON.
  2. Then populate the list with values from 0 to 100.
  3. Because the JSON is applied at the column level, the Complete column can use any name you want.
  4. The filled and empty square colors live in the JSON – change them to match your brand.
  5. Store the value in a Number column on a 0 to 100 scale (a decimal such as 0.73 will not display as 73 percent); the grid uses a compact 10 by 10 layout that stays readable without enlarging the row.

How to Apply JSON code

  1. On the Complete 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

JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "display": "flex",
    "flex-wrap": "wrap",
    "width": "79px",
    "gap": "1px"
  },
  "children": [
    {
      "elmType": "div",
      "forEach": "cell in split('0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99',',')",
      "style": {
        "width": "7px",
        "height": "7px",
        "border-radius": "1px",
        "background-color": "=if(Number([$cell]) < Number(@currentField), '#0f6cbd', '#e3e1df')"
      }
    }
  ]
}

Common Questions About the Percentage Grid

What is the Percentage Grid built with?

It is built with a standard Microsoft List (SharePoint list) and a small piece of column-formatting JSON. There is no custom development, no SPFx solution, and no third-party tools. It is the kind of clean, maintainable formatting Greg Zelfond builds for teams that want a completion column that reads as a proportion at a glance without ongoing development overhead.

What columns does it need?

It needs one Number column on a 0 to 100 scale, where the JSON is applied, plus any label column such as the project name. The grid is drawn entirely from that one value.

Does this design use any custom development or third-party tools?

No. It uses only out-of-the-box SharePoint column formatting, which Microsoft supports natively. That keeps it stable and easy to maintain, and nothing breaks when SharePoint is updated. Out-of-the-box is the only way Greg builds, so you can own and extend the design yourself for years.

If LookBook 365 is code-free and out-of-the-box, why does this example include JSON?

Because SharePoint formatting JSON is not custom code – it is a native configuration feature built into lists and libraries. It is declarative: it only describes how an existing column looks, and cannot run scripts, reach external services, or change your data. Nothing is deployed and nothing breaks when Microsoft updates SharePoint, and you can edit or remove it anytime. That is why LookBook 365 treats it as out-of-the-box and low risk.

Can I change the colors?

Yes. The filled square color and the empty square color are two values in the JSON. Swap them for your brand colors, and every square follows the change.

Can Greg build a design like this for our lists?

Yes – this is exactly the kind of work Greg Zelfond does. As an independent SharePoint consultant and Microsoft MVP, he designs out-of-the-box list and library formatting like this so your team can read and maintain it without a developer. Reach out through the contact page to talk about your lists.