{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "box-sizing": "border-box", "padding": "0 2px", "overflow": "hidden", "text-overflow": "ellipsis" }, "attributes": { "class": { "operator": ":", "operands": [ { "operator": "||", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Stage]", "4. Proposal Dev" ] }, { "operator": "==", "operands": [ "[$Stage]", "5. Post Subm Activities" ] } ] }, { "operator": "==", "operands": [ "[$Stage]", "6. Closed" ] } ] }, "", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": ">", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ null ] } ] } ] } ] } ] }, { "operator": "<", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] } ] }, "sp-css-backgroundColor-BgCoral sp-css-borderColor-CoralFont sp-css-color-CoralFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Wed Sep 18 2024" ] } ] } ] } ] } ] } ] }, "sp-css-backgroundColor-BgPeach sp-css-borderColor-PeachFont sp-css-color-PeachFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Fri Oct 11 2024" ] } ] } ] } ] } ] } ] }, "sp-css-backgroundColor-BgGold sp-css-color-GoldFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Wed Dec 11 2024" ] } ] } ] } ] } ] } ] }, "sp-css-backgroundColor-BgMintGreen sp-css-borderColor-MintGreenFont sp-css-color-MintGreenFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Tue Mar 11 2025" ] } ] } ] } ] } ] } ] }, "sp-css-backgroundColor-BgCyan sp-css-color-CyanFont", "sp-css-backgroundColor-BgLightGray sp-css-borderColor-LightGrayFont sp-css-color-LightGrayFont" ] } ] } ] } ] } ] } ] } }, "children": [ { "elmType": "span", "style": { "overflow": "hidden", "text-overflow": "ellipsis", "padding": "0 3px" }, "txtContent": "[$Deadline.displayValue]", "attributes": { "class": { "operator": ":", "operands": [ { "operator": "||", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Stage]", "4. Proposal Dev" ] }, { "operator": "==", "operands": [ "[$Stage]", "5. Post Subm Activities" ] } ] }, { "operator": "==", "operands": [ "[$Stage]", "6. Closed" ] } ] }, "", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": ">", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ null ] } ] } ] } ] } ] }, { "operator": "<", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] } ] }, "sp-css-color-CoralFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Wed Sep 18 2024" ] } ] } ] } ] } ] } ] }, "sp-css-color-PeachFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Fri Oct 11 2024" ] } ] } ] } ] } ] } ] }, "sp-css-color-GoldFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Wed Dec 11 2024" ] } ] } ] } ] } ] } ] }, "sp-css-color-MintGreenFont", { "operator": ":", "operands": [ { "operator": "&&", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "[$Status]", "Capture" ] }, { "operator": "==", "operands": [ "[$Status]", "Temporary Hold" ] } ] }, { "operator": "&&", "operands": [ { "operator": ">=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "@now" ] } ] } ] } ] }, { "operator": "<=", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Deadline]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "Tue Mar 11 2025" ] } ] } ] } ] } ] } ] }, "sp-css-color-CyanFont", "sp-css-color-LightGrayFont" ] } ] } ] } ] } ] } ] } } } ] }