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
-
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"))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!