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

Find more posts tagged with

Formulas

Accepted answers

Paul H

Try this

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.