Nested IF Statements for same date

Devin Porter
Devin Porter ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I'm trying to create a Nested IF formula utilizing the status bars and due dates. What we're trying to say in English is:

If more than 5 days til due date = GreenΒ 

If within 5 days of due date or equal to due date,Β  = Yellow

IfΒ  past due date = Red

I can get certain parts of the formula to work by themselves, but whenever I try to combine them into one cell I get back Unparseable.Β 

Β 

The formula I have that works is:Β 

=IF([Due Date]13 < TODAY(5), "Yellow", "")

or

=IF([Due Date]13 > TODAY(6), "Green", "Red")

When I combine them it breaks and I THINK it's because they contradict each other. As the 2nd one says if it's not greater than 6 days out it's Red, but the first one says if it's less than 5 it's Yellow. I can't figure out how to create this formula to do 3 different statuses.Β 

Β 

Help?

Β 

Thank you!

Β 

Β 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!