Forum Discussion

Copper Contributor

Apr 09, 2021

Solved

JSON if statement for conditional formatting

I am new at JSON and would like some help on how to write an if statement for conditional formatting in a SharePoint list that will change a columns background (@currentField) color if the Position c...

SharePoint Online

RobElliott

Apr 09, 2021

JTFInc you need to use || which stands for or (&& is and) as follows:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "padding-left": "14px",
    "background-color": "=if([$Position] == 'Chief Cook' || [$Position] =='Cook' || [$Position] == 'Steward'  , '#00afff', '#d7dae1')",
    "color": "black"
  }
}

I've used this JSON to format the Contract column in the image below:

Rob
Los Gallardos
Microsoft Power Automate Community Super User

RobElliott

Silver Contributor

Apr 09, 2021

JTFInc you need to use || which stands for or (&& is and) as follows:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "padding-left": "14px",
    "background-color": "=if([$Position] == 'Chief Cook' || [$Position] =='Cook' || [$Position] == 'Steward'  , '#00afff', '#d7dae1')",
    "color": "black"
  }
}

I've used this JSON to format the Contract column in the image below:

Rob
Los Gallardos
Microsoft Power Automate Community Super User

sam77meyer
Copper Contributor
Nov 28, 2023
Hi RobElliott, hoping you can assist in a similar situation.

I've got a Sharepoint list with folders and excel files that either have a response due date or do not. I want a column field to be visible only if the list entity is an excel file with a listed response due date.

The below JSON has successfully hidden the field for folders, but my second conditional to hide the field if the 'Responses Due' column is blank is not working.
carlos_vargas
Copper Contributor
Jul 07, 2022
Thank you RobElliott,

Elegant solution and easy to use

I have implemented it this way
"display": "=if(([$Column1] == 'Value1' || [$Column1] == 'Value2') && [$Column2] != 'Value3', 'display', 'none')"
Jennifer Gonzalez
Copper Contributor
Jul 23, 2021
RobElliott Hi. I attempted this but I got all the same color as my background. Is this possible to use on a calculated column?
- kurt6
  Copper Contributor
  Aug 20, 2021
  i have a column approver2 with the value of the name in it.
  there is also a approver1.
  if approver2 rejected, the name should be bold, if approver1 rejected name sould be normal.
  
  is that possible?
  
  thanks kuno
JTFInc
Copper Contributor
Apr 09, 2021
Rob your a champion! That did the trick. I was playing with all kinds of operands and could not make it work. Thanks again for your help. Your awesome.
Regards
Jay