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
Accounts receivable=0
Account receivable>0, but payment method=cash on delivery
The goods arrive date before today and today.
THANK YOU SO MUCH~
Regards,
Chelsea
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
No.
Use the expression I provided.
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)
=Question=
Does it meet my purpose?
When I use the unauthorised [USEREMAIL]
& [Accounts receivable]>0 to select Deliverable,
The system agreed to this choice, and no invalid messages appeared.
How can I solve this problem?
Thank you very much~
Regards,
Chelsea
Thatโs for you to answer.
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
IN(โNeedleโ,Haystack)
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 USEREMAIL to [currently visiting user].
When the user who is visiting = ABC @gmail.com, the restriction is lifted.
The current situation is that [USEREMAIL] in excel is the first time writer (e.g. DD@gmail.com.
So invalidation occurs.
How can I modify it?
Thanks~
Regards,
Chelsea
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |