IFS with OR Formula not working

[Excellent022]

I have a deliverable tracker that I need to update in include "unpaid" as a final status. My spreadsheet worked with the following formula:
=IFS([@[Deliverable Accepted 1?]]="","Pending",[@[Deliverable Accepted 1?]]="N/A","N/A",OR([@[Deliverable Accepted 1?]]="Yes",[@[Deliverable Accepted 2?]]="Yes",[@[Deliverable Accepted 3?]]="Yes"),"Yes",OR([@[Deliverable Accepted 1?]]="Monitor",[@[Deliverable Accepted 2?]]="Monitor",[@[Deliverable Accepted 3?]]="Monitor"),"Monitor",[@[Deliverable Accepted 1?]]="No","No")

However, when I added "unpaid" as a data validation list option to the last Deliverable status column (Deliverable Accepted 1?) and updated to formula to the following, it keeps the result cell "no".

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

Here's what my new formula returns:

Final Status	Deliverable Accepted 1?	Deliverable Accepted 2?	Deliverable Accepted 3?
Yes	No	No	Yes
No	No	No	No
Monitor	No		Monitor
No	No	No	Unpaid
Monitor	Monitor	Monitor	Unpaid

 

[Alex Blakenburg]

You're welcome. Glad I could help.