Rule Engine with values from another column
Hi I am trying to build a formula to assign a certain value if the content of the column is equal to some values in an array else take the value from another column in the table.
I did the formula below:
$Column 1$ IN (“Value 1”, “Value 2”,“Value 3”) => “Mickey Mouse”
TRUE=>$Column 2$
but all I got is ? in every row for the newly create column.
What am I missing?