How to set up Valid If formulas in different states in the enumlist?

[CHELSEA1]

Hello /Chelsea,

How to set up Valid If formulas in different states in the enumlist ?

TABLES : ORDER
Column name : Order Status
Type: Enum
Values: 1. Open
2. Deliverable

How to set the Valid If formula?

The following 4 conditions must be met at the same time,
then the “Deliverable” in [Order Status] can be opened to click…

1.USEREMAIL()=ABC@gmail.com

2. Accounts receivable=0

3. Account receivable>0, but payment method=cash on delivery

4. The goods arrive date before today and today.

THANK YOU SO MUCH~

Regards,
Chelsea