Custom column with non mutual exclusive categories

i am trying to create a custom column that can create non -mutually exclusive categories if [category]=A then A , if [category]=B then B , if [category]=c then c, if[category] = A or B, combo1, i...

Need Help

Tips and Tricks

Anonymous

4 years ago

HI bjha,

You can create the conditions with these conditions, but the first condition should have a higher priority to check all matched items than the others.

formula =
IF (
    Table[category] IN { "A", "B" },
    //both A, B will trigger this conditions
    "combo1",
    IF ( Table[category] IN { "B", "C" }, 
        //Only C trigger this, it has a hidden conditions that the records does not match with previous conditions.
        "combo2" )
)

Regards,

Xiaoxin Sheng

formula = IF ( Table[category] IN { "A", "B" }, //both A, B will trigger this conditions "combo1", IF ( Table[category] IN { "B", "C" }, //Only C trigger this, it has a hidden conditions that the records does not match with previous conditions. "combo2" ) )

Forum Discussion

Custom column with non mutual exclusive categories