SharePoint List Formatting
Back to column formats
Column formattingSharePoint Online

Task Matrix

The Eisenhower Matrix is like a map for managing your tasks. It helps you decide what needs to be done first, what can wait, what can be given to someone else, and what can be left aside.

Get this format View on GitHub

Shared by Larry Pfaff
Updated Apr 2, 2024

Task Matrix formatting preview
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.

Column formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "display": "=if(@currentField,'inline','none')"
  },
  "attributes": {
    "title": "@currentField"
  },
  "children": [
    {
      "elmType": "div",
      "style": {
        "max-width": "155px",
        "min-width": "145px",
        "width": "100%",
        "display": "flex",
        "margin": "1px",
        "align-items": "center",
        "justify-content": "center",
        "flex-wrap": "wrap",
        "flex-direction": "row"
      },
      "children": [
        {
          "elmType": "div",
          "txtContent": "Do",
          "style": {
            "display": "flex",
            "min-height": "45px",
            "height": "100%",
            "max-width": "65px",
            "width": "100%",
            "background-color": "='rgba(132, 189, 0,' + if(@currentField == '2.2', 1, .2) + ')'",
            "color": "#fff",
            "border-radius": "5px",
            "border-width": "2px",
            "border-style": "solid",
            "border-color": "rgba(35, 30, 25, 1)",
            "flex-basis": "40%",
            "align-items": "center",
            "justify-content": "center",
            "flex-direction": "column",
            "font-size": "1.2em",
            "font-family": "sans-serif"
          },
          "attributes": {
            "title": "=if(@currentField == '2.2', 'Do: Tasks with deadlines or consequences', if(@currentField == '2.1', 'Decide: Schedule Tasks for later with unclear deadlines that contribute to long-term success', if(@currentField == '1.2', 'Delegate: Tasks that must get done but don\\'t require your specific skill set.', if(@currentField == '1.1', 'Delete: Distractions and unnecessary tasks.',''))))"
          }
        },
        {
          "elmType": "div",
          "txtContent": "Decide",
          "style": {
            "display": "flex",
            "min-height": "45px",
            "height": "100%",
            "max-width": "65px",
            "width": "100%",
            "background-color": "='rgba(241, 180, 52,' + if(@currentField == '2.1', 1, .2) + ')'",
            "color": "#fff",
            "border-radius": "5px",
            "border-width": "2px",
            "border-style": "solid",
            "border-color": "rgba(35, 30, 25, 1)",
            "flex-basis": "40%",
            "align-items": "center",
            "justify-content": "center",
            "flex-direction": "column",
            "font-size": "1.2em",
            "font-family": "sans-serif"
          },
          "attributes": {
            "title": "=if(@currentField == '2.2', 'Do: Tasks with deadlines or consequences', if(@currentField == '2.1', 'Decide: Schedule Tasks for later with unclear deadlines that contribute to long-term success', if(@currentField == '1.2', 'Delegate: Tasks that must get done but don\\'t require your specific skill set.', if(@currentField == '1.1', 'Delete: Distractions and unnecessary tasks.',''))))"
          }
        },
        {
          "elmType": "div",
          "txtContent": "Delegate",
          "style": {
            "display": "flex",
            "min-height": "45px",
            "height": "100%",
            "max-width": "65px",
            "width": "100%",
            "background-color": "='rgba(0, 40, 85,' + if(@currentField == '1.2', 1, .2) + ')'",
            "color": "#fff",
            "border-radius": "5px",
            "border-width": "2px",
            "border-style": "solid",
            "border-color": "rgba(35, 30, 25, 1)",
            "flex-basis": "40%",
            "align-items": "center",
            "justify-content": "center",
            "flex-direction": "column",
            "font-size": "1.2em",
            "font-family": "sans-serif"
          },
          "attributes": {
            "title": "=if(@currentField == '2.2', 'Do: Tasks with deadlines or consequences', if(@currentField == '2.1', 'Decide: Schedule Tasks for later with unclear deadlines that contribute to long-term success', if(@currentField == '1.2', 'Delegate: Tasks that must get done but don\\'t require your specific skill set.', if(@currentField == '1.1', 'Delete: Distractions and unnecessary tasks.',''))))"
          }
        },
        {
          "elmType": "div",
          "txtContent": "Delete",
          "style": {
            "display": "flex",
            "min-height": "45px",
            "height": "100%",
            "max-width": "65px",
            "width": "100%",
            "background-color": "='rgba(164, 39, 45,' + if(@currentField == '1.1', 1, .2) + ')'",
            "color": "#fff",
            "border-radius": "5px",
            "border-width": "2px",
            "border-style": "solid",
            "border-color": "rgba(35, 30, 25, 1)",
            "flex-basis": "40%",
            "align-items": "center",
            "justify-content": "center",
            "flex-direction": "column",
            "font-size": "1.2em",
            "font-family": "sans-serif"
          },
          "attributes": {
            "title": "=if(@currentField == '2.2', 'Do: Tasks with deadlines or consequences', if(@currentField == '2.1', 'Decide: Schedule Tasks for later with unclear deadlines that contribute to long-term success', if(@currentField == '1.2', 'Delegate: Tasks that must get done but don\\'t require your specific skill set.', if(@currentField == '1.1', 'Delete: Distractions and unnecessary tasks.',''))))"
          }
        }
      ]
    }
  ]
}
View sourceLink to this definitiongeneric-eisenhower-matrix.json

From the contributor

How to use this sample

Summary

The Eisenhower Matrix is like a map for managing your tasks. It helps you decide what needs to be done first, what can wait, what can be given to someone else, and what can be left aside. Let's break it down into four boxes: things to do now, things to do later, things to pass on to others, and things to forget about. We'll show you how to use this tool and give you some tips for sorting out your tasks.

Understanding the difference between urgent and important is key here. Urgent means it needs to be done right away. If you ignore urgent tasks, there can be bad consequences, like missing a deadline or causing a bigger problem. These tasks are like fires you need to put out quickly to avoid getting burned out.

For example, finishing a project with a deadline, handling an urgent request from a client, or fixing something broken in your home are all urgent tasks. Now, important tasks might not be urgent, but they're still crucial for reaching your long-term goals. You need to plan for these tasks carefully so you can use your time and energy wisely. This could include planning a big project, meeting new people to grow your business, or just doing regular chores to keep things running smoothly.

screenshot of the sample

View requirements

The format expects the following fields:

Type Internal Name Notes
Choice Importance Options - High, Low
Choice Urgency Options - High, Low
Calculated field - Single line of text EMatrix Formula - =IF(AND(Importance<>"",Urgency<>""),IF(Importance="High",2,1)&"."&IF(Urgency="High",2,1),"") or =IF(AND(Importance<>"";Urgency<>"");IF(Importance="High";2;1)&"."&IF(Urgency="High";2;1);"")

[!NOTE]
The delimiter in the formula for the Calculated field is a comma (,) or semi-colon (;), but the available ones depend on the locale of the site. (Reference: Calculated Field Formulas)

Sample

Solution Author(s)
generic-eisenhower-matrix.json Larry Pfaff

Version history

Version Date Comments
1.0 April 2, 2024 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.