Good Morning I have a SharePoint list and I want to apply conditional formatting if an item hasn't been submitted, in which case a Date field will be empty. I have applied other formatting based on whether a column contains data by simply picking the column, 'is equal to' or 'is not equal to' and then leave the last field blank. But that doesn't seem to work with a Date field. I've also tried to put the condition as 'Column' 'is not equal to' '1/1/1990' - in the hope that picking a date long ago, nothing will match but this doesn't work either. I have other conditions so I didn't really want to go to JSON. I don't know enough to work out how to put 3 conditions together! Is there any way to conditionally format based on the empty Date value? Thanks,Christine

Amapola67 you can format the date column in advanced mode as follows:{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(Number(@currentField) == 0, '#541417', 'green')", "color": "white" } } RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott Good staff is so hard to find these days I'm learning more about SharePoint these days than I ever wanted to know!! Have a good day!Christine

Amapola67,I realize this is a bit dated now, but I believe this can still be done with the out-of-the-box conditional formatting style editor --for those interested in just formatting an individual date column, by simply choosing the "is between" comparison and leaving the date selections empty.

RobElliott Thanks!But that only formats that field while I'm trying to format the entire item. As a work around, I've introduced a Status column but that means I need to manually update it ..

Amapola67 If you want to format entire row based on empty date column, you have to use view formatting.Example: { "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "additionalRowClass": "=if([$StartDate], '', 'sp-field-severity--severeWarning')" } Similarly, you can apply any of the predefined classes instead of 'sp-field-severity--severeWarning' as given in below links as per your requirements:Predefined classesReusable SharePoint Online Classes for Modern UISee other ways to check if date column is empty at: SharePoint JSON formatting: Check if date & time column is blank/emptyPlease 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.

Conditional Formatting based on empty Date column

Kregg1122
Copper Contributor
Nov 30, 2023
Amapola67,
I realize this is a bit dated now, but I believe this can still be done with the out-of-the-box conditional formatting style editor --for those interested in just formatting an individual date column, by simply choosing the "is between" comparison and leaving the date selections empty.
- marekurban83
  Copper Contributor
  Oct 08, 2024
  Very simpe but work perfect in my issue. Thx
- Amapola67
  Copper Contributor
  Nov 30, 2023
  Kregg1122
  
  Nice. I will have to try that. - Never too late to learn!
  
  Thank you!
RobElliott
Silver Contributor
Oct 29, 2021
Amapola67 you can format the date column in advanced mode as follows:

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

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- Amapola67
  Copper Contributor
  Oct 31, 2021
  RobElliott Thanks!
  But that only formats that field while I'm trying to format the entire item. As a work around, I've introduced a Status column but that means I need to manually update it ..
  - RobElliott
    Silver Contributor
    Nov 01, 2021
    Amapola67 "But that only formats that field while I'm trying to format the entire item" - it would have been helpful if you'd said that in your original post!
    
    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Forum Discussion

Conditional Formatting based on empty Date column

Resources