LinkedIn
Twitter
HI,STEVE
Thank you for your reply…
My Valid_If formula found an error！
=My formula=
AND
(IN([Order Status],“Deliverable”),(USEREMAIL="ABC@gmail.com"),[Accounts receivable]<=0)
=Error message=
Parameter 2 of function IN is of the wrong type
=Challenge=
I need to let those who meet the conditions at the same time
(for example…
[Accounts receivable]<=0))
Only then can you open the [Deliverable] option in Type’Enum’.
How can my formula be corrected? Or is there any other way?
Thank you very much~
Regards,
Chelsea
[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)
=Question=
But this did not bring me effective help,
Are there any other settings that need to be adjusted?
Or does this formula need to be adjusted?
Thank you very much~
Regards,
Chelsea
Your first attempt was actually pretty close:
In response to @Lynn’s post, you changed your expression to:
In your first try, AppSheet was complaining because your IN() expression, IN([Order Status],“Deliverable”), wasn’t given a list to look in. The first argument to IN() should be what you’re looking for; the second argument should be the list you’re looking in. "Deliverable" is not a list, so AppSheet complained.
In your second try, you used IN(“Deliverable”,{“Deliverable”}). {“Deliverable”} is, in fact, a list containing a single item, the text, Deliverable. That satisfies IN()'s requirement for a list. The problem here, though, is that the first argument is also the literal text, Deliverable. Your expression asks the question, does the word Deliverable occur in a list that consists only of the word Deliverable? Yes, it does. Always. Every time. Without fail. 
What you want is the best from both tries:
IN([Order Status], {"Deliverable"})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))
=Question=
Is the formula I set up correct?
Does it meet my purpose?
I found that after the actual operation, the operation is always invalid,
But I can’t figure out what went wrong.
Thank you very much~
Regards,
Chelsea
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 choice, and no invalid messages appeared.
Please help modify the formula?
Or how to solve the problem?
=Formula=
OR(
AND(IN([Order Status],{“Deliverable”}),([USEREMAIL]=" ABC @gmail.com"),( [Accounts receivable]<=0)),
OR(IN(“Order Status”,{“Open”}),TRUE))
= purpose =
Set up a formula in Valid If, so that it can be used in situation 1. or situation 2.
Thank you very much~
Regards,
Chelsea
