IF(OR Formula with Multiple Criteria

[Excellent022]

I have a spreadsheet that tracks vendor deliverables. The formula in Column D worked fine until now when need to add the status of "Monitor". If I need to kick back a deliverable that was not acceptable and it becomes acceptable, then Column D is correctly changing from No to Yes. What do I need to do to the formula to make it show Monitor if that is the final review status in either Columns Z or AK? I have a screenshot that helps explain.

 

[SanjayGMusafir]

Check this -

=IFS([@[Vendor Complaint 1?]]="","Pending",[@[Vendor Complaint 1?]]="N/A","N/A",OR([@[Vendor Complaint 1?]]="Yes",[@[Vendor Complaint 2?]]="Yes",[@[Vendor Complaint 3?]]="Yes"),"Yes",OR([@[Vendor Complaint 1?]]="Monitor",[@[Vendor Complaint 2?]]="Monitor",[@[Vendor Complaint 3?]]="Monitor"),"Monitor",[@[Vendor Complaint 1?]]="No","No")

 

[Excellent022]

Check this -

=IFS([@[Vendor Complaint 1?]]="","Pending",[@[Vendor Complaint 1?]]="N/A","N/A",OR([@[Vendor Complaint 1?]]="Yes",[@[Vendor Complaint 2?]]="Yes",[@[Vendor Complaint 3?]]="Yes"),"Yes",OR([@[Vendor Complaint 1?]]="Monitor",[@[Vendor Complaint 2?]]="Monitor",[@[Vendor Complaint 3?]]="Monitor"),"Monitor",[@[Vendor Complaint 1?]]="No","No")

Its giving me "the syntax of this name isn't correct" error.

 

[Excellent022]

Its giving me "the syntax of this name isn't correct" error.

Its giving me "the syntax of this name isn't correct" error.

I found the error, i and a in "compliant" was switched. This worked! I love this site...many thanks.

 

[SanjayGMusafir]

Actually, I mistyped word, try this -

=IFS([@[Vendor Compliant 1?]]="","Pending",[@[Vendor Compliant 1?]]="N/A","N/A",OR([@[Vendor Compliant 1?]]="Yes",[@[Vendor Compliant 2?]]="Yes",[@[Vendor Compliant 3?]]="Yes"),"Yes",OR([@[Vendor Compliant 1?]]="Monitor",[@[Vendor Compliant 2?]]="Monitor",[@[Vendor Compliant 3?]]="Monitor"),"Monitor",[@[Vendor Compliant 1?]]="No","No")

 

[SanjayGMusafir]

I found the error, i and a in "compliant" was switched. This worked! I love this site...many thanks.

Glad to help you