Format column if empty and have passed date with 7 days

Deleted
Not applicable

Need advise.

 

Can someone modify the following code so it format "Due date" as "red+warning sign" IF current field is empty AND Todays date has passed "Created" over 7 days. See illustration provided.

 

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": {
"operator": "?",
"operands": [
{
"operator": "<=",
"operands": [
"[$Created]",
{
"operator": "-",
"operands": [
"@now",
604800000
]
}
]
},
"#ff0000",
""
]
}
}
}

0 Replies