Nov 08 2021 09:46 PM
I would like to do some conditional formatting so that a column in a list is hidden until the previous column has some data in it.
like i imagine something like =ifnot([$Date1] == 'null', 'true', 'false')
is there something like an ifnot function and is null a an option for if there is nothing?|
Cheers
Sam
Nov 09 2021 02:50 AM - edited Apr 17 2023 04:05 AM
Solution@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.
Nov 09 2021 02:50 AM - edited Apr 17 2023 04:05 AM
Solution@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.