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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!