JSON Sharepoint - validating dates across several columns with boolean column

Question

I'm beginner/intermediate when it comes to SharePoint JSON, and I've been trying all sorts of conditional logic to make an empty column txtContent show 'Yes' or 'No'.

There are 7 columns (all date columns) that need to be validated in one sharepoint list - if ANY of them are overdue (equal to or less than @now), then new column should say 'No'. If all of them are greater than @now (or null) then 'Yes'.

I got this far (but of course it doesn't work). JSONLint says it's ok, but there's obviously something weird I'm doing that is keeping this column blank.

Can you see what I've missed or done incorrectly??? (probably loads)

    {
    "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",

    "elmType": "div",
    "txtContent": "='(' + if([$datecolumn1] <= @now, 'No', if([$datecolumn2] <= @now, 'No', if([$datecolumn3] <= @now, 'No', if([datecolumn4] <= @now, 'No',if([$datecolumn5] <= @now, 'No', if([$datecolumn6] <= @now, 'No', if([$datecolumn7] <= @now, 'No', 'Yes'))))))) + ')'",
    "style": {
        "background-color": "=if(txtContent == 'Yes', '#107c10', if(txtContent == 'No', '#e81123', ''))"
    }

}

Answer 1

You can use || (OR operand) to compare multiple columns.

Use below JSON to set the new column value to 'No' if any of the 7 Date columns are overdue else set 'Yes'.

Apply same condition to set the background-color as well.

{
    "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json", 
    "elmType": "div",
    "txtContent": "=if([$datecolumn1] <= @now || [$datecolumn2] <= @now || [$datecolumn3] <= @now || [datecolumn4] <= @now || [$datecolumn5] <= @now || [$datecolumn6] <= @now || [$datecolumn7] <= @now,'No','Yes')",
    "style": {
           "background-color": "=if([$datecolumn1] <= @now || [$datecolumn2] <= @now || [$datecolumn3] <= @now || [datecolumn4] <= @now || [$datecolumn5] <= @now || [$datecolumn6] <= @now || [$datecolumn7] <= @now,'#e81123','#107c10')"
     }
}