#UNPARSEABLE with multiple IF statements

Options

Hi,

I am trying to create TEXT depending on some conditional information.

I want to display text RED if my materials clear date is less than 7 days from my due and display text YELLOW if my materials clear date is less than 14 days (but greater than 7 days) and if my materials clear date is greater than 15 days, leave the cell blank.


Here is the formula I came up with -

=IF([Original Promised Ship Date]@row +7 < [Materials Clear]@row, “RED”, IF([Original Promised Ship Date]@row +14 < [Materials Clear]@row, “YELLOW”, IF([Original Promised Ship Date]@row +15 < [Materials Clear]@row, “”)))


What am I missing here?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!