Forum Discussion
ifnot empty conditional formatting (JSON) for sharpoint lists
EKIT415 You can use a formula like below to check if date column is blank or not:
=if([$DateField], 'true', 'false')Or
=if(Number([$DateField]) != 0, 'true', 'false')Where DateField is internal name of your date & time column.
See other ways to check if date column is blank or not using SharePoint JSON formatting: SharePoint JSON formatting: Check if date & time column is blank/empty
Related Read: How to find the Internal name of columns in SharePoint Online?
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.
EKIT415 You can use a formula like below to check if date column is blank or not:
=if([$DateField], 'true', 'false')
Or
=if(Number([$DateField]) != 0, 'true', 'false')
Where DateField is internal name of your date & time column.
See other ways to check if date column is blank or not using SharePoint JSON formatting: SharePoint JSON formatting: Check if date & time column is blank/empty
Related Read: How to find the Internal name of columns in SharePoint Online?
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.