SharePoint list date column validation

Question

Hello,

I've a SharePoint list with due date column field. I want to apply a condition like Ex: With in 10 days of the due date the item should show in "Red color" can you advise ? And also can we show as a bar kind of visual layout in a separate view if possible

PFA

Answer 1

@SR VSP

Based on your description, I understand that Due date is less than 10 days from today's date, then row background color displays in red. Here're steps:

1.All Documents -> Format current view -> Advanced mode.

2.Use below codes in the Advanced mode.

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",  
  "additionalRowClass": "=if([$DueDate]-@now< 10, 'sp-field-severity--severeWarning', '')"  
}  

3.Result.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

Answer 2

I'm not sure the calculation part of this works correctly. I tried it on a list of mine, and it only colors past entries (Due Date has already passed), not any future ones. Even items with a Due Date of tomorrow (now -1) aren't being affected.