Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Color code record if due date is this week

Topic Labels: Base design
Solved
Jump to Solution
2287 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: