Formatting a row in Microsoft Lists - Trying to change a row, but it changes everything.

Question

Hi All,

I have a library list in Lists for checking books in and out of our small church library. The column I am trying to add a condition to has a Date/Time format called Due Date. I click the column, click "Format this column", choose "Format View". I then click "add a rule", then add, If Due Date is before "Today", then turn row Red. Unfortunatley, it turns everything red. At the moment there is only one date in that column, dated for yesterday.

Can someone give me any answers as to why this rule applies itself to everything instead of that one row with the overdue date and a solution to fix it so only dates that are overdue are effected?

Thank you so much, I have pounded the web and ChatPT to to try and fix but alas I am at a loss !

Mal

Answer 1

Unfortunately nothing has worked as far as the facility in Lists goes. I had to do a work around with ChatPT, to create a JSON script on a calculation column, to produce an "Overdue" entry. Then used a rule to say when the field says overdue, turn the row to red, which has worked.

Unfortunatley, Microsoft made such a simple scenario as complicated as possible.

Answer 2

I am not using JSON, as I am not trained in that area. I am using the non advanced option that should work. It works for different rules and only effects the data I want it to be applied to. It is just with this date scenario that I am having difficulties.

Answer 3

It sounds like you are experiencing an issue with conditional formatting in Microsoft Lists where the rule you set is applying to all rows instead of just the one with the overdue date. This can happen if the condition is not set up correctly or if the formatting is applied at the view level rather than at the individual row level.

To ensure that only the rows with overdue dates are affected, you should check the following:

1. Condition Syntax: Make sure that the condition you are using is correctly referencing the Due Date column. The syntax should specifically check if the Due Date is less than or equal to today's date. The condition might look something like this in JSON format:

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

2. Apply to Rows: Ensure that you are applying the formatting to the rows and not just the column. The additionalRowClass property should be used to apply classes to the entire row based on the value of the Due Date.
3. Testing: After making changes, test the formatting by updating the Due Date to see if only the relevant rows change color.

If you continue to have issues, consider revisiting the formatting settings or consulting the documentation for more detailed examples of conditional formatting in Microsoft Lists.

---

References:

• List layout customizations
• Use column formatting to customize SharePoint