Nested IF(AND) ISBLANK all together?

I'm writing a formula to return priority timing based on days left until end date. Here's what I have.

=IF(AND((IF(ISBLANK([Working Days Left END DATE]@row)), "NEW"), IF(AND([Working Days Left END DATE]@row <= 3, [Working Days Left END DATE]@row > 0), "URGENT(0-3 days)", IF(AND([Working Days Left END DATE]@row > 3, [Working Days Left END DATE]@row < 10), "SOON (3-10 days)", IF(AND([Working Days Left END DATE]@row > 10), "UP NEXT (10+ days)", IF(AND([Working Days Left END DATE]@row < 0), "OVERDUE", )))))

It was all working until I wanted it to return "NEW" for the blank option.

Here's what I'm looking for:

Working Days Left, <0 = Overdue

Working Days Left, 0 - 3 = Urgent

Working Days Left, 3-10 = Soon

Working Days Left, 10+ = Up Next

Working Days Left, Blank = NEW


All help is soooo appreciated! Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!