Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,436 questions
Format columns with time interval (today + 7 days) in MS Lists using JSON
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 26%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Meyer, Alexander
0
Reputation points
Hello,
I've been trying to find a clean solution for my "MS Lists" for some time.
Here's the initial situation:
In the "Sprint" column there is a date when the corresponding entry is scheduled for the next sprint.
In order to get a better graphical representation of whether the date is coming up soon or has even already passed, I took the following steps:
If
Sprint
is on or before
Today
Display list item as: white text on a red background
If
Sprint is between
Today & 7/8/2024 (7 days into future from today)
Display list item as: black text on a yellow background
Unfortunately, with the second formatting there is no way to say "Today + 7 days"
In JSON there is the option of using "now+7d". Unfortunately, Lists can't do anything with that.
Are there other JSON commands that I can use to get MS List to achieve the desired effect without having to change the date in the conditional formatting every single day?
Thanks and regards,
Alexander
Office