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

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