Using formulas for Date validation within 7, 14 and 30 days


I am trying to use the following formula: 

=IF[Due Date] <=7, "Red", 

IF[Due Date] > 7 and <=14, "Yellow")

IF [Due Date] > 14 and < 30, "Green")

How do I do that, I tried to create a new column to show the colors, but I keep getting Invalid Operation. 

=IF(([Due Date]1) > 7, (AND([Due Date]1) < 14), "Red"),

IF([Due Date]1) > 14, (AND([Due Date]1) < 30), "Yellow"),

IF([Due Date]1) > 30, "Green")

Any help is much appreciated!

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!