Column Coditions

[Jerome_Canete]

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.

[Douglas_English]

Try

IFS( [A]=“boy”, TRUE, [A]=“girl”, TRUE, [A]=“none”, “N/A”)

[Jerome_Canete]

Thank for this @Douglas_English, unfortunately it broke my app…
it just converted my column into a yes/no type.

[Steve · Accepted solution]

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"})

[Jerome_Canete]

Tried 'em @Steve, but didn’t work as expected. It still didn’t fill in the “N/A” output in my source table. Thanks anyway.

[LeventK]

Steve:

Initial value expression for column B :

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

@Steve,
I believe a slight mod is needed for your Initial Value expression as per @Jerome_Canete’s description

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

[Steve]

Whoops! Thanks, @LeventK!

[Jerome_Canete]

Wow, nice… that did just the trick. Thanks @LeventK…

Another thing, need some more help with same scenario but instead of text type columns, I’d like to work on enum and enumlist columns. Thanks in advance.

[LeventK]

Thanks @Jerome_Canete, but you shall thank to @Steve actually, mine was just an eye-catch, that’s all. So kudos to him.

[Steve]

Teamwork, friends.

[Jerome_Canete]

Of course, big thanks first of all to @Steve…