Share via

SharePoint Lists' Conditional Formatting Very Limited!

Anonymous
2021-11-26T12:00:01+00:00

Hello, I'm finding the conditional formatting options for MS Lists very limited compared to the choice you have in MS Excel and other competitor products like Smartsheet. As an organisation, we're in a position where we're trying to make the most of our enterprise agreement with Microsoft, with a potential view to migrate our Smartsheet users over to the Office 365 suite of products.

One particular use case I'm trying to migrate across is an asset management tracker, which I know there's a template for MS Lists. One requirement is to have either the entire row and/or the Due Date column to appear in differing colours, depending on how close to the Due Date column it is. This is certainly possible, but only with limited parameters:

In Excel or Smartsheet, you tend to get a wider set of parameters, such as:

What I'd really like is for the entire row and/or the Due Date column to appear in red when the date in the Due Date column is 7 days away or less.

I'm aware this might be possible through the Advanced Options by using JSON language to code this, however, I'm struggling to figure it out.

I've found a few articles online, such as: https://github.com/pnp/List-Formatting/tree/master/column-samples/date-range-format and https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-formatting-based-on-date-ranges, but I am a novice at this and I'm struggling to work out how to tweak this to suit the above.

Any ideas and pointers would be much appreciated! Thank you in advance.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-26T13:45:13+00:00

    Hi SteCoxy,

    Thank you for posting your query in our community.

    Based on your description, you want to use JSON code to add more parameters in Microsoft Lists.

    About the formatting method JSON, since it is related to the site customization coding, you can go to Microsoft Q & A community, members who have the similar query solved their problem in this community: list view - json formatting not showing all items - Microsoft Q&A, the members and engineers in this community are more experienced in this area, so my suggestion is to post your problem in there. You will get a more detailed and professional answer to your problem there.

    Thanks for your understanding.

    Best regards,

    Jazlyn

    0 comments