Nested IF(AND) ISBLANK all together?

Sonja Lukin-Beck

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!

Paul Newcome

Try this one...

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