IF Functions and Dates

Chelsea LeBlanc · 04/06/20

Hi All,

I am trying to use an IF function with dates. For example, IF a date is less than 15 days, return green, less than 30 days, return yellow and more than 30 days return red. When I tried typing this function in using the correct symbols and true/false values, I get an error message. I am creating a log of requests, but there is not a due date associated with the request, only the date the request was initiated. I'm trying to flag requests as green, yellow or red, if they are 15 days or newer (green), 16 - 30 days old (yellow) and more than 30 days old (red).

Is there a way to do this?

Thank you!

Andrée Starå · 04/06/20

Hi Chelsea,

Excellent!

Glad you got it working!

One tip. I’d recommend using @row so you don’t need to think about row numbers.

=IF(Done@row = 1, "Gray", IF([Date Logged]@row <= TODAY(-30), "Red", IF([Date Logged]@row <= TODAY(-15), "Yellow", "Green")))

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Chelsea LeBlanc · 04/06/20

I got ahead of myself, but was able to get it figured out. I also added a column to indicate if something is marked as Done to turn it gray. Hope this can help someone.

=IF(Done2 = 1, "Gray", IF([Date Logged]2 <= TODAY(-30), "Red", IF([Date Logged]2 <= TODAY(-15), "Yellow", "Green")))

Andrée Starå · 04/06/20