Forum Discussion

AnatolyD's avatar
AnatolyD
Copper Contributor
Oct 13, 2020

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 colu...
Conditional Formatting
date and text
json
JSON formatting
AnatolyD's avatar
AnatolyD
Copper Contributor
Oct 13, 2020

ganeshsanap 

Hello! thanks.

 

I tried this one

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": "=if((@currentField < @now) && [PHASE]='Investigation', '#f7adad', if((@currentField <= @now + 864000000) && [PHASE]='Investigation', '#f2d596', if((@currentField >= @now + 864000000) && [PHASE]='Investigation' , '#a0dec0', '')))"
}
}

 

But something is wrong....

 

Column values disappear, like with a wrong condition.

 

 

You proposed an option for 2 colors, but I m using 3 colors.

Sorry, I m not familiar with this syntax....

 

Column name is "PHASE"

 

 

ganeshsanap's avatar
ganeshsanap
MVP
Oct 13, 2020

AnatolyD , Use below condition:

 

 

=if((@currentField < @now) && [$PHASE]='Investigation', '#f7adad', if((@currentField <= @now + 864000000) && [$PHASE]='Investigation', '#f2d596', if((@currentField >= @now + 864000000) && [$PHASE]='Investigation' , '#a0dec0', '')))

 

 

If you want to apply the background color only if PHASE="Investigation" then you can use below condition as well:

 

 

=if([$PHASE]='Investigation', if(@currentField < @now, '#f7adad', if(@currentField <= (@now + 864000000), '#f2d596', if(@currentField >= (@now + 864000000), '#a0dec0', ''))), '')

 

Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.

 

  • AnatolyD's avatar
    AnatolyD
    Copper Contributor
    Oct 13, 2020

    ganeshsanap RobElliott 

     

    Hello!

    Sorry, may be I m a little dumb, but

    something is still wrong.

     

     

    I tried both ways

     

    {
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": "=if([$PHASE]='Investigation', if(@currentField < @now, '#f7adad', if(@currentField <= (@now + 864000000), '#f2d596', if(@currentField >= (@now + 864000000), '#a0dec0', ''))) , '')"
}
}

    and

    {
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": "=if((@currentField < @now) && [$PHASE]='Investigation', '#f7adad', if((@currentField <= @now + 864000000) && [$PHASE]='Investigation', '#f2d596', if((@currentField >= @now + 864000000) && [$PHASE]='Investigation' , '#a0dec0', '')))"
}
}

     

    PHASE has a single line of text type, not Choice.

     

     

     

Resources