IF AND Formula with Multiple Criteria

cochrank

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

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

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