Forum Discussion
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...
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)