Can you format date columns based on if they are empty?

Occasional Contributor

I am aware how to format columns based on dates but i can not figure out a way to make the column turn red if there is no date entered. Please can somebody help me out with this? Thank you

1 Reply

@LukeJSmith Yes, you can format date columns using JSON if they are empty.


Here's sample JSON expression to check if date column is empty or not:


=if(Number([$DueDate]) == 0, 'Blank Date', 'Not Blank')


You can find other ways to check if date & time column is blank/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.