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.
Solved! Go to 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"})
Try
IFS( [A]=โboyโ, TRUE, [A]=โgirlโ, TRUE, [A]=โnoneโ, โN/Aโ)
Thank for this @Douglas_English, unfortunately it broke my appโฆ
it just converted my column into a yes/no type.
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"})
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.
@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"
)
Whoops! Thanks, @LeventK!
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.
Thanks @Jerome_Canete, but you shall thank to @Steve actually, mine was just an eye-catch, thatโs all. So kudos to him.
Teamwork, friends.
Of course, big thanks first of all to @Steveโฆ
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |