Nested Ifs to show progress on an assignment
I have three scenarios I'm trying to string together. Each of the formulas works when they're separate but I can't figure out how to nest them correctly. In what order should they be nested (replacing "Test" with the next criteria)?
If "Assigned To" is blank and "Actual Completion Date" is blank, then "Unassigned"
If "Assigned To" is not blank and "Actual Completion Date" is blank, then "Assigned"
If "Assigned To" is not blank and "Actual Completion Date" is not blank, then "Closed"
=IF(AND(((ISBLANK([Assigned To]@row))), ISBLANK([Actual Completion Date]@row)), "Unassigned", "Test")
=IF(AND(NOT(ISBLANK([Assigned To]@row)), ISBLANK([Actual Completion Date]@row)), "Assigned", "Test")
=IF(AND(NOT(ISBLANK([Assigned To]@row)), NOT(ISBLANK([Actual Completion Date]@row))), "Closed", "Test")
Best Answer
-
Try this
=IF(ISBLANK([Assigned To]@row), "Unassigned", IF(ISBLANK([Actual Completion Date]@row), "Assigned", "Closed"))
Answers
-
Try this
=IF(ISBLANK([Assigned To]@row), "Unassigned", IF(ISBLANK([Actual Completion Date]@row), "Assigned", "Closed"))
-
@Paul H That's perfect and much simpler!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!