Solved: Column Coditions - Page 2

Jerome_Canete · 06-27-2020 08:09 PM

Hi,
Seeking advise here. I can’t seem to work around with the exact expression:

Column A is text column with a valid_if statement {“boy”,“girl”,“none”},
Column B is also a text column with a valid_if statement {“one”,“two”,“three”} and a show_if condition OR([A]=“boy”,[A]=“girl”) and all just works fine but here’s where I can’t move forward because additionally, I also want column B to just put in “NA” remark whenever a user chooses “none” in column A. I tries this expression in the formula [A]=“none”.“NA” but not working.

Thanks in advance for any help.

BR.

Steve

Valid If expression for column B:

IF(
  IN([A], {"boy", "girl"}),
  {"one", "two", "three"},
  {"N/A"}
)

Initial value expression for column B:

IFS(
  IN([A], {"boy", "girl"}),
    "N/A"
)

Editable? expression for column B:

IN([A], {"boy", "girl"})

View solution in original post