formatting the column by JSON when reference to a choice field

Question

Hi, ich have a problem! The conditional formatting should reference a choice field. If the cell is empty ("") and the column 'Equipmenttyp' has the value 'Example Device', the cell should be red. I tried also with "lookupvalue" and "value", but is not working :

{

"elmType": "div",

"style": {

Copy

"background-color": "=if(and([$Equipmenttyp] == 'Example Device', @currentField == ''), '#FFC7CE', '')"

},

"children": [

Copy

{

  "elmType": "span",

  "txtContent": "@currentField"

}

]

}

Answer 1

Hi @Tuncel Biyikli ,

Using the following json formatting code:

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"padding-left": "14px",
"background-color": "=if(@currentField == '' &&(indexOf([$Equipmenttyp], 'Apparat') != -1), 'red', '')",
"color": "=if(@currentField == '' &&(indexOf([$Equipmenttyp], 'Apparat') != -1), 'red', '')"
 }
}

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Tuncel Biyikli ,

1.You should use view formatting to customize SharePoint List. Because you're referencing other columns.

Using the following json code , when the choice column is empty (“”) and the value of the “Equipmenttyp” column is “Example Device”, the entire row will be displayed in red.

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$choice]=='' && [$Equipmenttyp] == 'Example Device' ,'ms-bgColor-red ms-fontColor-black', '')"
}

2.You can format choice column so that when choice column is empty (“”) and the value of the “Equipmenttyp” column is “Example Device”, the cell should be red.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi @Tuncel Biyikli ,

Using the following json formatting code:

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"padding-left": "14px",
"background-color": "=if(@currentField == 'Apparat' && [$Example]=='', 'red', '')",
"color": "=if(@currentField == 'Apparat' && [$Example]=='', 'white', '')"
 }
}

Output：

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Hello, thank you for your support. It's working now. The reason was the internal name of the column.