Compare 2 columns of a Sharepoint list

[444456464]

Hello, I would like to compare the "Estimation" column with the "Temps passe" column if the  "Statut" column is selected as "Terminée" with this method :

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#create-s...

My SharePoint list with the columns concerned :

I tried this but it doesn't work, and I couldn't even add the condition to it "if the "Statut" column has the choice "Terminée" :

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "span",
      "attributes": {
        "class": "=if([$Tempspasse] > [$Estimation], 'sp-field-trending--up', 'sp-field-trending--down')",
        "iconName": "=if([$Tempspasse] > [$Estimation], 'SortUp', if([$Tempspasse] < [$Estimation], 'SortDown', ''))"
      }
    },
    {
      "elmType": "span",
      "txtContent": "[$Tempspasser]"
    }
  ]
}

Can you help me please ?

[#2 · Accepted solution]

@444456464 try the following:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "class": "=if([$Statuit] == 'Terminée' && @currentField > [$Estimation], 'sp-field-trending--up', if([$Statuit] == 'Terminée' && @currentField < [$Estimation], 'sp-field-trending--down', ''))"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "=if([$Statuit] == 'Terminée' && [$Tempspasse] > [$Estimation], 'SortUp', if([$Statuit] == 'Terminée' && [$Tempspasse] < [$Estimation], 'SortDown', ''))"
      }
    },
    {
      "elmType": "span",
      "txtContent": "[$Tempspasse]"
    }
  ]
}

which results in:

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#3]

Thank you so much !

[#4]

How did you get the bubble like display in the Statuit column?

[#5]

@jfi74 it's just the out-of-the-box choice pills. Click the down arrow next to the Choice column heading, select column settings -> format this column -> choice pills.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)