Compare 2 columns of a Sharepoint list

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-simple-data-visualizations

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 ?

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)

RobElliott

Silver Contributor

Jan 22, 2022

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)

jfi74
Copper Contributor
Jan 26, 2023
How did you get the bubble like display in the Statuit column?
- RobElliott
  Silver Contributor
  Jan 26, 2023
  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)
444456464
Copper Contributor
Feb 14, 2022
Thank you so much !

Forum Discussion

Compare 2 columns of a Sharepoint list

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 :

Share

Resources