Initial value expression

[Phong_Lam1]

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

[Aurelien · Accepted 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",
  ""
)

[Marc_Dillon]

Remove the highlighted portion of your expression.

[Phong_Lam1]

I was close . Thanks @Aurelien, @Marc_Dillon !