IF AND Formula with Multiple Criteria

Hi there, I've searched so many threads and tried parsing together how this would work for my scenario but I keep getting an invalid argument. I have a column for "Status" and I want to incorporate a formula to auto select the status based on other cell criteria:

Open: If "Date Shipped to Supplier" is blank

At Supplier: If "Date Shipped to Supplier" is not blank

Reworked: If "Return Date" is not blank

Closed: If "Rework Pass/Fail" is "Pass"

Rework Failed: If "Rework Pass/Fail" is "Fail"

So far I got here but gave up:

=IF(ISBLANK([Date Shipped to Supplier]@row), "Open", IF(AND(NOT(ISBLANK([Date Shipped to Supplier]@row)), ISBLANK([Return Date]@row)), "At Supplier"), IF(AND(NOT(ISBLANK([Date Shipped to Supplier]@row))), NOT(ISBLANK([Return Date]@row))), "Reworked")

Any help is appreciated, thank you!!

Kendra

Find more posts tagged with

IF(AND

IF(

Accepted answers

Soumitra Bhowmick

Try this

=IF([Rework Pass/Fail]@row = "Pass", "Closed", IF([Rework Pass/Fail]@row = "Fail", "Rework Failed", IF(ISBLANK([Return Date]@row) = false, "Reworked", IF(ISBLANK([Date Shipped to Supplier]@row), "Open", "At Supplier"))))

All comments

Soumitra Bhowmick

Try this

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.