Microsoft Teams/ Lists JSON

Copper Contributor

Hello, 

 

I'm currently using Teams and Lists to track our universities certifications. I found a JSON's that allowed me to make the numbers of the dates red when expired, yellow within 30 days, and green if futher than 30 days. 

 

I'm wanting to add another format that will make the cell completely red when there is no date entered to make it stand out that there isn't information there. Below is the current JSON I have entered.

 

 

{
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": "=if(@currentField <= @now, 'red',if(@currentField <= @now + 2592000000 && @currentField > @now,'orange','green'))",
"font-weight": "=if(@currentField <= @now, 'bold',if(@currentField <= @now + 2592000000 && @currentField > @now,'semi-bold','normal'))"
}
}
 
Thanks!
1 Reply

Here is a visual. 

 

jordannbowman_0-1654173816903.png