Select IF condition from list and create another list aside from creating data source

[imsorrymen]

Hi, I’m totally newbie here. I wish someone could help me to get some formula to be used in valid if.
Assuming I had 2 item selection from Transaction column, INCOMING and OUTGOING. If I selected incoming, the category column will have another list of items. The list must be “DELIVERIES”, “SAMPLE”, “INTERBRANCH”. While OUTGOING will select “SALES”, “BREAKAGE”, “SAMPLE”, " PULL-OUT"

I have this formula in valid if area to category column. but it dint work.

Can another help me on this?

IFS(
[TRANSACTION] = “INCOMING”, LIST(“DELIVERIES”, “SAMPLE”, “INTERBRANCH”),
[TRANSACTION] = “OUTGOING”, LIST(“SALES”, “BREAKAGE”, “SAMPLE”, " PULL-OUT"),
TRUE,“”
)

[Aurelien · Accepted solution]

Hi @imsorrymen

It should be list output at anytime in your case.
So, you probably want to pick either:

IFS(
  [TRANSACTION] = “INCOMING”, LIST(“DELIVERIES”, “SAMPLE”, “INTERBRANCH”),
  [TRANSACTION] = “OUTGOING”, LIST(“SALES”, “BREAKAGE”, “SAMPLE”, "PULL-OUT"),
  TRUE,LIST(“”)
)

or

IFS(
  [TRANSACTION] = “INCOMING”, LIST(“DELIVERIES”, “SAMPLE”, “INTERBRANCH”),
  [TRANSACTION] = “OUTGOING”, LIST(“SALES”, “BREAKAGE”, “SAMPLE”, "PULL-OUT")
)

In my opinion, 2nd option is better

[imsorrymen]

Aurelien:

IFS(
  [TRANSACTION] = “INCOMING”, LIST(“DELIVERIES”, “SAMPLE”, “INTERBRANCH”),
  [TRANSACTION] = “OUTGOING”, LIST(“SALES”, “BREAKAGE”, “SAMPLE”, "PULL-OUT")
)

This is much better. Thank you