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!
