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 |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |