Hi all, in a form, I have a column [Exclusivity duration] type Enum with 3 options as below
I want to put an expression that if [status] (in the same table) = A or= B or= C than [Exclusivity duration] will be “Always”, if not , user can choose “6 months” or “No exclusivity”. I try this expression but not work
IF(OR([Status]=“A”,[Status]=“B”,[Status]=“C”),[Exclusivity duration]=“Always”,"")
Thanks
Solved! Go to Solution.
Hi @Phong_Lam
In the Valid_If of the column [Exclusivity duration]:
IF(
OR([Status]="A",
[Status]="B",
[Status]="C"
),
LIST("Always"),
LIST("6 months","No exclusivity")
)
In the Initial_Value:
IF(
OR([Status]="A",
[Status]="B",
[Status]="C"
),
"Always",
""
)
Hi @Phong_Lam
In the Valid_If of the column [Exclusivity duration]:
IF(
OR([Status]="A",
[Status]="B",
[Status]="C"
),
LIST("Always"),
LIST("6 months","No exclusivity")
)
In the Initial_Value:
IF(
OR([Status]="A",
[Status]="B",
[Status]="C"
),
"Always",
""
)
Remove the highlighted portion of your expression.
I was close . Thanks @Aurelien, @Marc_Dillon !
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |