Conditional formatting of SharePoint List Column

Question

Conditional formatting of SharePoint List Column

Paul Spurr 0

I have a SharePoint custom list with multiple date columns. I want to format the date in a column (Pt1 Returned) to display red text when that date exceed the value of another (date) column (48hr Deadline). Simple conditional format only allows the condition to be today or a specific (selected) date.

Put simply, if Pt1 Returned is greater than 48hr deadline, the value of Pt1 Returned is highlighted red.

Can JSON code be used to create the format, if so, I've not used JSON before so would be grateful to anyone who can suggest code to make this work.

Thanks

2 answers

Your answer

Answer 1

Renjie Sun-MSFT 2,861 Microsoft Employee

Hi Paul Spurr •

Thanks for the post.

You could refer to the following code template:

Using column formatting in 'Date' column. (Pt1)
If the 'Date' value is greater than 'deadline' Date + 48 hours, the character turns red.

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"debugMode": true,

"txtContent": "@currentField",

"style": {

"color": "=if(@currentField>=([$deadline]+(1000*60*60*48)), '#ff0000', ' ')"

}

Testingresult:

User's image

I hope I can offer you a better experience next time if I have a chance to work with you again.

Yours faithfully,

Renjie Sun

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.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee

2023-01-17T02:10:12.7666667+00:00

Hi @Paul Spurr,

Do you have any further questions about this thread? If you have any questions or progress, you can contact me in time.

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

Answer 2

Paul Spurr 0

Thanks for providing an answer, unfortunately it is not working, but I think that is my fault.

My original post didn't include the actual name of the 'deadline' column and I don't know where to find how it should appear. The actual heading of the column is 48hr Part 1 Deadline.

Can you please advise how this should appear in the coding =([$?????]

User's image

Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee

2023-01-18T01:47:17.06+00:00

Thanks for the reply.

Please confirm that both of your column is 'Date' column.

It works well in my tests.
Xuyan Ding - MSFT 7,601 Reputation points

2023-01-23T10:23:32.5733333+00:00

Hi Paul,

I am checking to see if the problem has been resolved . If you have any questions you can feel free to contact us.
Xuyan Ding - MSFT 7,601 Reputation points

2023-01-26T10:08:05.98+00:00

Hi Paul Spurr

Is there any progress on this thread? Please feel free to let us know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-01-31T05:43:13.3466667+00:00

Hi Paul Spurr •

You can sort the column and get the internal namein the URL from the SortField parameter value.

Or you can go to list settings, under the Column section, click on any of the columns, and you can get the column internal name in the URL from the Field parameter value.E.g. In my case, it’s: “NEWETA”

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

2023-02-06T11:13:01.07+00:00

Following your instruction, I get this result for the field name - Field=Part_x0020_1_x0020_Returned.

I presume the _x0020 represents a blank space
Paul Spurr 0 Reputation points

2023-02-06T16:15:47.76+00:00

I've renamed the column 'Pt1 Due' and reapplied the coding, amending the element ([$deadline] with ([Pt1 Due] and it returned the same error message - Failure: Pt1 Due was not found on the data object.

In answer to Renjie Sun, both columns are Date/time.
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-02-09T03:06:36.6166667+00:00

As I said, this format in Json uses the internal name of the column, regardless of whether you modify the column name or not. I suggest you try the internal name you got to see if the problem still exists.

Share via

Conditional formatting of SharePoint List Column

2 answers

Your answer