I basically have a calculated column that shows the date 1/29/1900
if there are some empty values in the other columns.
Is there a way to use JSON formatting to format it so that if the column displays 1/29/1900 it shows empty instead?
I was trying to mess with this code below but it's not working properly.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"attributes": {
"class": "=if(@currentField = 1/29/1900,'sp-field-severity--warning', '')"
},
"children": [
{
"elmType": "span",
"style": {
"display": "inline-block",
"padding": "0 4px"
},
"attributes": {
"iconName": "=if(@currentField == 1/29/1900,'Error', '')"
}
},
{
"elmType": "span",
"txtContent": ""
}
]
}