Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,707 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
Sign in to answer