Forum Discussion
Conditional Formatting based on empty Date column
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" } }Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)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:
See other ways to check if date column is empty at: SharePoint JSON formatting: Check if date & time column is blank/empty
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.
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.
- Very simpe but work perfect in my issue. Thx
