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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!