JSON conditional format column based on choice from another column

Question

I am using SharePoint online. I have a choice column and a text column, If the choice "phone" is selected from the choice column, I want the text column to change color. For some reason it wont work - both columns are in view, any help would be greatly appreciated!

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "color": "=if([$ContactMethod] == 'Phone', '#66ff33', '')"
  }
}

Answer 1

If the source column allows multiple value selections, SharePoint stores those selections as an array of values inside the field. Therefore, matching on a single string value will never succeed against a field that allows multiple values, even if the user only chose one value, the value is still in an array. In the example you have posted above, as long as the column is configured to allow multiple values, even if a user only chose the "Phone" option, your IF check is trying to compare the string 'Phone' to a single item array containing the word 'Phone'.

So, instead of ==, you need to use the indexOf function. Your JSON should look something like this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "color": "=if(indexOf([$ContactMethod], 'Phone') != -1, '#66ff33', '')"
  }
}