Forum Discussion

Penelope680's avatar
Penelope680
Copper Contributor
Feb 08, 2026

Conditional formatting not possible

Hello together,

SharePoint isn't displaying the relative date options "in 7 days" and "in 14 days," even though I've selected "is on or before." Normally, clicking "Today (relative)" should bring up a dropdown menu.

 

But it doesn't!

 

What could be causing this?

 

Thx

SharePoint Online

2 Replies

  • virendrak's avatar
    virendrak
    Iron Contributor
    Feb 09, 2026
    • Can you confirm the column type? Is it a Date column, or is it a Calculated / Lookup / Choice / Text column?
    • Where are you clicking to expect the ‘Today (relative)’ dropdown 
  • UsmanKhalil's avatar
    UsmanKhalil
    Copper Contributor
    Feb 08, 2026

    Try to use "Advanced Mode" (JSON)

    If the dropdown menu simply won't appear, you can manually set the "7 days" or "14 days" logic using Advanced Mode. This is the most reliable way to ensure your formatting works regardless of UI bugs.

    Open the Format this column pane.

    Click Advanced mode at the bottom.

    Paste a JSON code similar to this (replaces [$DueDate] with your internal column name)

Resources