Changing Color Symbols by Number of Days from Due Date

Options

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", ))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!