JSON using multiple conditions within IF statement

Hi slw_wills,

It seems (at least to me) that there are some syntax errors in your JSON code you are using. To fix it, you may need to correct the placement of parentheses and make sure the syntax is correct for the IF statements. Here's an updated version of the JSON you can try to adapt to your code:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": "=if(@currentField <= @now && ([$Document_x0020_Type] == 'Service Agreement' || [$Document_x0020_Type] == 'Contract'), 'red', if(@currentField <= @now + 5184000000 && @currentField > @now && ([$Document_x0020_Type] == 'Service Agreement' || [$Document_x0020_Type] == 'Contract'), 'orange', if(@currentField > @now + 5184000000 && ([$Document_x0020_Type] == 'Service Agreement' || [$Document_x0020_Type] == 'Contract'), 'green', 'black')))"
}
}

Just a short explanation:

• The document type conditions are added using parentheses ( and ) to ensure the correct evaluation order.
• The && operator is used to combine the conditions for the document type and the expiry date.
• The || operator is used to check if the document type is either "Service Agreement" or "Contract" for each color condition.

Also just make sure to update it to use the actual column name in your SharePoint list (Document_x0020_Type).