Nested Ifs to show progress on an assignment

Gabby Nepomuceno

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")

Paul H

Try this

=IF(ISBLANK([Assigned To]@row), "Unassigned", IF(ISBLANK([Actual Completion Date]@row), "Assigned", "Closed"))

Paul H

Try this

=IF(ISBLANK([Assigned To]@row), "Unassigned", IF(ISBLANK([Actual Completion Date]@row), "Assigned", "Closed"))

Gabby Nepomuceno

@Paul H That's perfect and much simpler!