Conditional Formatting SharePoint List
Hello team, I need your support with conditional JSON formatting of SharePoint list. I would like to format column INVEST_DUE_DATE based on current date (date cell) and based on value in column Phase (string). Right now, I implemented just formatting based on date, using following code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField < @now , '#f7adad', if(@currentField <= @now + 864000000, '#f2d596', if(@currentField >= @now + 864000000 , '#a0dec0', '')))" } } I want to apply additional condition for it - use color formatting only if value of cell Phase = Investigation. So , it should be something like this (@currentField < @now) and @[$Phase]='Investigation' , '#f7adad', and etc.... But it does not works.... Could you please advise me how to modify initial JSON code? Thank you in advance!
