I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns.

Here is what I was trying to set up:

(1) IF @ColumnName1 = "status 4" THEN @ColumnName2 be highlighted red if the cell is blank.
(2) IF @ColumnName3 = "" THEN @ColumnName4 be highlighted red if the cell is blank.

And more functions similar to them.

I have written some code, but I am not entirely sure how to create argument reference to another column. How this can be done?

Thank you in advance.

  • Check this: sharepoint.stackexchange.com/questions/233951/… – P S Mar 28 at 9:43
  • You can get the current column value using @currentField and other fields can be referenced as for example: [$DueDate]. – Ganesh Sanap Mar 28 at 9:48
  • @Ganesh Sanap So here's my condition (what I want to set up): [link]IF Status = "status 4" THEN Current Field be highlighted red if the cell is blank And here's my code: 'code'{ "elmType": "div", "attributes": { "class": "=if(AND([$Status] == 'statust 4',@CurrentField == '') ,'sp-field-severity--blocked,'')" }, { "elmType": "span", "txtContent": "@currentField" } } Do you know what's wrong here? – Szymon Apr 1 at 10:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.