Format Column in Lists based off of Dates in the Column and another Column

Question

Hello,

I want to create a completion date column in my Sharepoint list that turns red if the date in it is past the due date. Here is what I have:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"attributes": {
"class": "=if([$Completion_x0020_Date] >= [$Due_x0020_Date],'sp-field-severity--severeWarning', '')"
}
}

This code does simply turns every entry red. Has someone encountered this before?

Answer 1

Hello @Ramirez, Nicholas ,

Welcome to Q&A Forum!

Please check your columns' DisplayName:
List Settings>> scroll to Columns section >> click on the specific columns

Here is Column Format:

{  
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",  
"elmType": "div",  
"txtContent": "@currentField",  
"attributes": {  
"class": "=if([$DueDate] <= [$CompletionDate], 'sp-field-severity--severeWarning', '')"  
}  
}  

Thanks,
Echo Du

======================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.