SharePoint List Formatting
Back to view formats
View formattingSharePoint Online

To-Do List

This sample formats your SharePoint list view to look like Microsoft To Do.

Get this format View on GitHub

Shared by João Ferreira
Updated Mar 4, 2022

Timeline in Board View
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.

View formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "hideSelection": true,
  "hideListHeader": true,
  "rowFormatter": {
    "elmType": "div",
    "style": {
      "padding": "5px",
      "min-width": "97%",
      "border-bottom": "1px solid #e5e5e5"
    },
    "attributes": {
      "class": "ms-bgColor-neutralLight--hover ms-fontColor-neutralSecondary–hover"
    },
    "children": [
      {
        "elmType": "div",
        "customRowAction": {
          "action": "setValue",
          "actionInput": {
            "Status": "=if([$Status], '0' , '1' )"
          }
        },
        "attributes": {
          "class": "ms-fontColor-themePrimary",
          "iconName": "=if([$Status], 'SkypeCircleCheck' , 'CircleRing')"
        },
        "style": {
          "font-size": "1.2rem",
          "cursor": "pointer",
          "padding-left": "10px"
        }
      },
      {
        "elmType": "div",
        "style": {
          "text-align": "left",
          "padding": "5px",
          "margin-left": "10px",
          "width": "100%"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "font-weight": "400",
              "font-size": "14px",
              "text-decoration": "=if([$Status], 'line-through' , '')"
            },
            "txtContent": "[$Title]"
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "10px",
              "margin-right": "5px",
              "color": "=if([$Status], '', if(toLocaleDateString([$Duedate])==toLocaleDateString(@now),'#465efc',if([$Duedate] < @now, '#db3a29' , '')))",
              "display": "=if([$Duedate],'','none')"
            },
            "attributes": {
              "iconName": "Event"
            }
          },
          {
            "elmType": "span",
            "style": {
              "font-weight": "=if([$Status], '200', if([$Duedate] < @now, '500' , '200'))",
              "font-size": "12px",
              "overflow": "hidden",
              "margin-top": "2px",
              "white-space": "nowrap",
              "color": "=if([$Status], '', if(toLocaleDateString([$Duedate])==toLocaleDateString(@now),'#465efc',if([$Duedate] < @now, '#db3a29' , '')))",
              "display": "=if([$Duedate],'','none')"
            },
            "txtContent": {
              "operator": "+",
              "operands": [
                "=if(toLocaleDateString([$Duedate])==toLocaleDateString(@now),'Today ',if([$Duedate] > @now, 'Due, ' , 'Overdue, '))",
                "=if(toLocaleDateString([$Duedate])!=toLocaleDateString(@now), [$Date], '')"
              ]
            }
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "12px",
              "margin": "0 10px",
              "font-weight": "900",
              "display": "=if([$Description]=='', 'none', if([$Duedate],'','none'))"
            },
            "txtContent": "·"
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "10px",
              "display": "=if([$Description]=='', 'none', '')"
            },
            "attributes": {
              "iconName": "QuickNote"
            }
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "12px",
              "margin": "0 10px",
              "font-weight": "900",
              "display": "=if([$Category]=='', 'none', '')"
            },
            "txtContent": "·"
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "11px",
              "display": "=if([$Category]=='', 'none', '')"
            },
            "attributes": {
              "iconName": "Tag"
            }
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "11px",
              "font-weight": "200",
              "margin-left": "5px",
              "display": "=if([$Category]=='', 'none', '')"
            },
            "txtContent": "[$Category]"
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "12px",
              "margin": "0 10px",
              "font-weight": "900",
              "display": "=if([$Attachments] == '0', 'none', '')"
            },
            "txtContent": "·"
          },
          {
            "elmType": "span",
            "style": {
              "font-size": "11px",
              "display": "=if([$Attachments] == '0', 'none', '')",
              "cursor": "pointer"
            },
            "attributes": {
              "iconName": "Attach"
            },
            "customRowAction": {
              "action": "defaultClick"
            }
          }
        ]
      },
      {
        "elmType": "span",
        "attributes": {
          "iconName": "=if([$_CommentCount], 'Comment', 'CommentAdd')",
          "class": "=if([$_CommentCount], 'ms-fontColor-themePrimary', '')"
        },
        "style": {
          "font-size": "14px",
          "padding-right": "15px",
          "cursor": "pointer"
        },
        "customRowAction": {
          "action": "defaultClick"
        }
      },
      {
        "elmType": "span",
        "attributes": {
          "iconName": "=if([$Important], 'FavoriteStarFill', 'FavoriteStar')",
          "class": "=if([$Important], 'ms-fontColor-themePrimary', '')"
        },
        "style": {
          "font-size": "16px",
          "padding-right": "10px",
          "cursor": "pointer"
        },
        "customRowAction": {
          "action": "setValue",
          "actionInput": {
            "Important": "=if([$Important], '0' , '1' )"
          }
        }
      }
    ],
    "customCardProps": {
      "formatter": {
        "elmType": "div",
        "style": {
          "padding": "20px"
        },
        "children": [
          {
            "elmType": "div",
            "children": [
              {
                "elmType": "div",
                "style": {
                  "width": "350px",
                  "font-size": "14px",
                  "font-weight": "700",
                  "margin-bottom": "5px"
                },
                "txtContent": "[$Title]",
                "inlineEditField": "[$Title]"
              },
              {
                "elmType": "div",
                "style": {
                  "width": "350px",
                  "font-size": "14px",
                  "font-weight": "400",
                  "margin-bottom": "5px",
                  "font-style": "=if([$Description]=='','Italic','')"
                },
                "txtContent": "=if([$Description]=='','Add note','[$Description]')",
                "inlineEditField": "[$Description]"
              },
              {
                "elmType": "div",
                "style": {
                  "width": "350px",
                  "font-size": "12px",
                  "font-weight": "200",
                  "margin-bottom": "5px"
                },
                "children": [
                  {
                    "elmType": "span",
                    "style": {
                      "font-size": "11px"
                    },
                    "attributes": {
                      "iconName": "Event"
                    }
                  },
                  {
                    "elmType": "span",
                    "style": {
                      "font-size": "12px",
                      "margin-left": "5px",
                      "font-weight": "200",
                      "font-style": "=if('=toLocaleDateString([$Duedate])'=='','Italic','')"
                    },
                    "txtContent": "=if('=toLocaleDateString([$Duedate])'=='','Add due date', '=toLocaleDateString([$Duedate])')",
                    "inlineEditField": "[$Duedate]"
                  }
                ]
              },
              {
                "elmType": "div",
                "style": {
                  "width": "350px",
                  "font-size": "12px",
                  "font-weight": "200",
                  "margin-bottom": "10px",
                  "padding-bottom": "10px",
                  "border-bottom": "1px solid #e5e5e5"
                },
                "children": [
                  {
                    "elmType": "span",
                    "style": {
                      "font-size": "11px"
                    },
                    "attributes": {
                      "iconName": "Tag"
                    }
                  },
                  {
                    "elmType": "span",
                    "style": {
                      "font-size": "12px",
                      "margin-left": "5px",
                      "font-weight": "200",
                      "font-style": "=if([$Category]=='','Italic','')"
                    },
                    "txtContent": "=if([$Category]=='','Pick a category',[$Category])",
                    "inlineEditField": "[$Category]"
                  }
                ]
              },
              {
                "elmType": "div",
                "children": [
                  {
                    "elmType": "div",
                    "style": {
                      "font-size": "12px",
                      "font-weight": "200"
                    },
                    "txtContent": {
                      "operator": "+",
                      "operands": [
                        "Created: ",
                        "=toLocaleString([$Created])"
                      ]
                    }
                  },
                  {
                    "elmType": "div",
                    "style": {
                      "margin-bottom": "5px"
                    },
                    "children": [
                      {
                        "elmType": "img",
                        "style": {
                          "width": "12px",
                          "height": "12px",
                          "border-radius": "50%",
                          "margin-right": "5px"
                        },
                        "attributes": {
                          "src": "=getUserImage([$Author.email], 'S')",
                          "title": "[$Author.title]"
                        }
                      },
                      {
                        "elmType": "span",
                        "txtContent": "[$Author.title]",
                        "style": {
                          "font-size": "12px",
                          "font-weight": "200"
                        }
                      }
                    ]
                  },
                  {
                    "elmType": "div",
                    "style": {
                      "font-size": "12px",
                      "font-weight": "200"
                    },
                    "txtContent": {
                      "operator": "+",
                      "operands": [
                        "Updated: ",
                        "=toLocaleString([$Modified])"
                      ]
                    }
                  },
                  {
                    "elmType": "div",
                    "children": [
                      {
                        "elmType": "img",
                        "style": {
                          "width": "12px",
                          "height": "12px",
                          "border-radius": "50%",
                          "margin-right": "5px"
                        },
                        "attributes": {
                          "src": "=getUserImage([$Editor.email], 'S')",
                          "title": "[$Editor.title]"
                        }
                      },
                      {
                        "elmType": "span",
                        "txtContent": "[$Editor.title]",
                        "style": {
                          "font-size": "12px",
                          "font-weight": "200"
                        }
                      }
                    ]
                  },
                  {
                    "elmType": "span",
                    "style": {
                      "font-size": "14px",
                      "cursor": "pointer",
                      "position": "absolute",
                      "bottom": "20px",
                      "right": "20px"
                    },
                    "attributes": {
                      "iconName": "Delete"
                    },
                    "customRowAction": {
                      "action": "delete"
                    }
                  }
                ]
              }
            ]
          }
        ]
      },
      "openOnEvent": "hover",
      "directionalHint": "bottomCenter",
      "isBeakVisible": true,
      "beakStyle": {
        "backgroundColor": "white"
      }
    }
  },
  "groupProps": {
    "headerFormatter": {
      "elmType": "div",
      "style": {
        "flex-direction": "row"
      },
      "children": [
        {
          "elmType": "div",
          "style": {
            "padding": "4px 8px 5px 8px",
            "border-radius": "6px",
            "font-weight": "500",
            "cursor": "pointer"
          },
          "attributes": {
            "class": {
              "operator": "+",
              "operands": [
                "ms-bgColor-themePrimary ",
                "ms-fontColor-white"
              ]
            }
          },
          "children": [
            {
              "elmType": "div",
              "style": {
                "display": "inline-flex",
                "padding-right": "9px"
              },
              "children": [
                {
                  "elmType": "div",
                  "style": {
                    "padding-left": "5px"
                  },
                  "attributes": {
                    "class": "ms-fontWeight-bold"
                  },
                  "txtContent": "=if(@group.fieldData.displayValue == 'Yes', 'Completed', 'To Do')"
                },
                {
                  "elmType": "div",
                  "style": {
                    "padding-left": "5px"
                  },
                  "attributes": {
                    "class": "ms-fontWeight-normal"
                  },
                  "txtContent": {
                    "operator": "+",
                    "operands": [
                      " - ",
                      "=@group.count",
                      "= if(@group.count!= 1,' items',' item')"
                    ]
                  }
                }
              ]
            }
          ]
        }
      ]
    }
  }
}
View sourceLink to this definitionto-do.json

From the contributor

How to use this sample

Summary

This sample formats your SharePoint list view to look like Microsoft To Do.

screenshot of the sample

View requirements

Column Name Type
Title Single Line Text
Description Multi Line Text
Category Choice
Due date Date and time
Important Yes/No, with default value set to No
Status Yes/No, with default value set to No
Date Calculated, as a single line of text using the formula: =CONCATENATE(TEXT(WEEKDAY([Due date]),"ddd"),", ",TEXT([Due date],"mmmm dd, yyyy"))

More info and details

This sample and all the options and decisions made to implement it, is explained in detail in a serie of articles:

1️⃣ List Definition
2️⃣ List view customization
3️⃣ To Do list template

A resumed version of the articles is also available in video format

🎥 Creating a To Do list for Microsoft Lists and SharePoint using View Formatting

Sample

Solution Author(s)
to-do.json João Ferreira

Version history

Version Date Comments
1.0 March 4, 2022 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.

Keep exploring

More formats like this

Key Dates Timeline Checklist

A modern horizontal timeline view that displays key dates or milestones as monthly columns.

Explore format

Sports Card

This SharePoint JSON view formatting sample transforms list items into vertical sports trading cards with header bar, country badge, player silhouette, name band, star rating and three stat bars.

Explore format

Credit / Loyalty Card

Transforms list items into realistic credit / loyalty cards with a brand name, tier pill, EMV chip, contactless symbol, embossed card number, cardholder, expiry, and network logo. The card colour is driven by the Tier value.

Explore format