JSON nested if's limit?

Copper Contributor

I've got a problem with my column formatting JSON. Some rows it's not applying any formatting to, and thus are blank, even though there is data in them.

 

I'm assuming that there is either an item limit (too many items in list, then the formatting doesn't format everything, or too many nested if's.


List view currently has 215 items in it.

 

This is my JSON,

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "class": "= if([$Shipper]=='Seago',if([$GIN_x0020_Date]=='','',if([$Tracking_x0020_ETA]=='','',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+864000000,'sp-field-severity--blocked',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+777600000,'sp-field-severity--warning',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+86400000,'sp-field-severity--blocked',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+129600000,'sp-field-severity--warning','sp-field-severity--good')))))),if([$GIN_x0020_Date]=='','',if([$Tracking_x0020_ETA]=='','',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+604800000,'sp-field-severity--blocked',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+518400000,'sp-field-severity--warning',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+86400000,'sp-field-severity--blocked',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+129600000,'sp-field-severity--warning','sp-field-severity--good'))))))"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "= if([$Shipper]=='Seago',if([$GIN_x0020_Date]=='','',if([$Tracking_x0020_ETA]=='','',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+864000000,'StatusErrorFull',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+777600000,'WarningSolid',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+86400000,'ErrorBadge',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+129600000,'Warning','Ferry')))))),if([$GIN_x0020_Date]=='','',if([$Tracking_x0020_ETA]=='','',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+604800000,'StatusErrorFull',if([$GIN_x0020_Date]>[$Tracking_x0020_ETA]+518400000,'WarningSolid',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+86400000,'ErrorBadge',if([$GIN_x0020_Date]<[$Tracking_x0020_ETA]+129600000,'Warning','Ferry'))))))"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

 

Here's a pic of the list showing the 'blank' fields - that do actually have values in them!

 

SPerr.png

 

Please help!

Thanks!

0 Replies