Forum Discussion

AdmiralS's avatar
AdmiralS
Copper Contributor
May 11, 2020

JSON for Formatting Dates

I currently have a SharePoint list that we use for tracking Insurance Policy Expiration dates.  I would like it to format with the warning format for dates that are within the next 30 days.  I have r...
Lists
SharePoint Online
AdmiralS's avatar
AdmiralS
Copper Contributor
May 11, 2020

Thanks!

 

I need to color for 3 scenarios against the same column though -

 

Red - Dates Before Today

Yellow- Dates between Today and 30 days out

Green - Dates 30 days and forward from Today

 

Can I do that all in the same JSON conditional filter?

Vikram_Samal's avatar
Vikram_Samal
MCT
May 11, 2020

AdmiralS Yes just you have to use multiple Ifs I have shown an example which can follow and modify as per your need.

This is the code:

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "@currentField",
   "style": {
      "color": "=if([$Color] == 'Red', 'red', if([$Color] == 'Green', 'green',if([$Color] == 'Blue', 'Blue', if([$Color] == 'Yellow', 'Yellow', 'Orange'))))"
   }
}

Hope this helps mark the response appropriately if it helps to solve your problem.

Resources