Forum Discussion

SarahC690's avatar
SarahC690
Copper Contributor
Oct 07, 2024

Conditional Formatting - Sharepoint List

It has been a while since using sharepoint lists and I am a bit out of practice!   I have set up a list which shows a list of Assessments which each staff member needs to complete and the date it e...
Lists
Rob_Elliott's avatar
Rob_Elliott
Silver Contributor
Oct 07, 2024

SarahC690 you would format the date column in advanced mode, deleting whatever's there and paste in the following:

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(Number(@currentField) == 0, 'gray', if(@currentField >= @now, 'green', '#fb6767'))",
    "color": "white",
    "padding-left": "4px"
  }
}

 

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources