Forum Discussion

57Andy's avatar
57Andy
Copper Contributor
Jan 24, 2024

Sharepoint List - Formatting codes for a date column and a choice column

Hi I'm trying to sort out a bit of code, but going nowhere. I have two columns one a date column (update date) that I want to turn red once the date hits 21 days old, so it acts as a reminder, the se...
Lists
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Jan 25, 2024

57Andy Assuming you want to turn Update date field Red when there is no update for last 21 days (Update date is older than today - 21 days), you can use JSON column formatting for your update date column like: 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if([$Status]=='Closed', '#CAF0CC', if(@currentField < addDays(@now, -21),'#D13438',''))",
    "color": "=if([$Status]=='Closed', '#437406', if(@currentField < addDays(@now, -21),'#FFFFFF',''))",
    "padding-left": "15px"
  }
}

 

Where [$Status] is an internal name of your Status column in SharePoint list in this format: [$InternalNameOfColumn]. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?

 

Output: 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources