Format column if empty and have passed date with 7 days

%3CLINGO-SUB%20id%3D%22lingo-sub-305675%22%20slang%3D%22en-US%22%3EFormat%20column%20if%20empty%20and%20have%20passed%20date%20with%207%20days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-305675%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20modify%20the%20following%20code%20so%20it%20format%20%22Due%20date%22%20as%20%22red%2Bwarning%20sign%22%20IF%20current%20field%20is%20empty%20AND%20Todays%20date%20has%20passed%20%22Created%22%20over%207%20days.%20See%26nbsp%3Billustration%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%22%24schema%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%22txtContent%22%3A%20%22%40currentField%22%2C%3CBR%20%2F%3E%22style%22%3A%20%7B%3CBR%20%2F%3E%22color%22%3A%20%7B%3CBR%20%2F%3E%22operator%22%3A%20%22%3F%22%2C%3CBR%20%2F%3E%22operands%22%3A%20%5B%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%22operator%22%3A%20%22%26lt%3B%3D%22%2C%3CBR%20%2F%3E%22operands%22%3A%20%5B%3CBR%20%2F%3E%22%5B%24Created%5D%22%2C%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%22operator%22%3A%20%22-%22%2C%3CBR%20%2F%3E%22operands%22%3A%20%5B%3CBR%20%2F%3E%22%40now%22%2C%3CBR%20%2F%3E604800000%3CBR%20%2F%3E%5D%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%5D%3CBR%20%2F%3E%7D%2C%3CBR%20%2F%3E%22%23ff0000%22%2C%3CBR%20%2F%3E%22%22%3CBR%20%2F%3E%5D%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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