Hi, Lynn Thanks for reply… The formula has been adjusted, But I found another problem… Is USEREMAIL equal to the login email being accessed? Or is it the first time or former writer? This text… [USEREMAIL]=" ABC @gmail.com " I need to change USEREMAI...

Hi ,Steve, Thank you for your reply… After using it, there is a problem… situation 1 . Open Fits my purpose. situation 2 . Deliverable: When I use the unauthorised [USEREMAIL] & [Accounts receivable]>0 to select Deliverable, The system agreed to this...

Hi ,Steve, Thank you for your reply… I used the expression you provided and changed the formula. =Formula= OR( AND(IN([Order Status],{“Deliverable”}),([USEREMAIL]=" ABC @gmail.com"),( [Accounts receivable]<=0)), OR(IN([Order Status],{“Open”}),TRUE) =...

Hi ,Steve, Thank you for your reply… Thank you very much, I corrected the formula… = purpose = =Formula= AND( AND(IN**(“Order Status”,{“Deliverable”}),([USEREMAIL]=" ABC @gmail.com"),( Accounts receivable]<=0)), OR( IN(“Order Status”,{“Open”}),TRUE))...

[quote=“CHELSEA, post:3, topic:50996”] HI,LYNN Thank you for your reply… My Valid_If formula is adjusted as follows, there is no error message. =Formula= AND(IN(“Deliverable”,{“Deliverable”}),[USEREMAIL]=“ABC@gmail.com”,[Accounts Receivable]<=0) =Que...