Changing Color Symbols by Number of Days from Due Date

Jessica Krueger

I'm trying to show the risk of a project running off of today's date compared to due date.

Here is the criteria:

If less than or equal to 3 days to due date from today color Red.

If greater than 3 days but less than 8 days to due date from today color Yellow.

If greater than or equal to 8 days to due date from today color Green.

Here's what I have but I keep getting an Unparseable error:

=IF([Pendo Due Date]@row <= Today (3), "Red", IF(AND([Pendo Due Date]@row > Today (3), [Pendo Due Date]@row < Today (8)), "Yellow", IF([Pendo Due Date]@row >= Today (8), "Green", ))

Jessica Krueger

Dumb mistakes on my part. Thank you for looking at it.

Jeff Reisman

Try this. There were a few issues with yours. First, TODAY() is a function and should be capitalized, with no space before the (0). There was a missing parentheses to close out your AND statement. And there was an extra comma at the end.

=IF([Pendo Due Date]@row <= TODAY(3), "Red", IF(AND([Pendo Due Date]@row > TODAY(3), [Pendo Due Date]@row < TODAY(8)), "Yellow", IF([Pendo Due Date]@row >= TODAY(8), "Green"))

Jessica Krueger

Dumb mistakes on my part. Thank you for looking at it.