Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Color code record if due date is this week

Topic Labels: Base design
Solved
Jump to Solution
2726 4
cancel
Showing results for 
Search instead for 
Did you mean: 
RP1
5 - Automation Enthusiast
5 - Automation Enthusiast

Is it possible to color code a record based on a due date, but just the ones that are in the current week?

Example: Today is Thursday, so all the records with a today or tomorrow (Friday) due date would be colored red.

I know that color based on “within the next week” or “within X number of days” exists, but I need the records for the current week only.

Thanks!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

I would create a formula field that compares this week to the week of the due date like this:

IF(
WEEKNUM(TODAY()) = WEEKNUM({Due Date}),
"This Week"
)

Then, you can color code based on the result of that formula.

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

I would create a formula field that compares this week to the week of the due date like this:

IF(
WEEKNUM(TODAY()) = WEEKNUM({Due Date}),
"This Week"
)

Then, you can color code based on the result of that formula.

This will work, though minor correction: WeekNum() is the formula to use. The following method also exists to get the week #, though is longer: DateTime_Format({Due Date}, “w”).

Oops, thanks for catching my mistake! :grinning: I just fixed it above!

RP1
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Scott, the formula works.

It’s a bummer that it’s not an option in the Color code dialogue though.
I’ll just hide the formula column and pretend it doesn’t exist. :slightly_smiling_face: