Forum Discussion
SLCLARKE23
Mar 25, 2022Copper Contributor
Conditional Formatting in Sharepoint List based on expiry date within 30 days
I currently have a list which shows training. the box shades red when the training has expired and is green when it is active. I would like it to go Orange when the training is going to expire in the...
SOE_Tech
Feb 21, 2023Brass Contributor
Can i be so bold and ask how to to "nothing" if the current field is empty?
With the current JSON the empty fields get red as well
With the current JSON the empty fields get red as well
ganeshsanap
Feb 19, 2024MVP
You can find different/multiple ways to check if SharePoint date & time column is empty or not using JSON formatting 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.