Multiple Box

[#1]

I have a multiple selection box.

Cars:

LOAD * Inline [

CARS

Ferrari

Porsche

Rolls Royce

Suzuki

];

Now i am looking for a formula

If i have selected in the cars the value Ferrari then i want to show a specific column

I have next formula

If((Match(CARS,'Ferrari') = 1),1,0)

but it doesn't work if i have selected ferrari and porsche at the same time.

does anyone know?

[crystles]

Perhaps if you tried using WildMatch() it wouldn't look for JUST the one selection, but whether it was selected at all?

[#3 · Accepted solution]

Try this formula:

alt(WildMatch(GetFieldSelections(CARS,'|'),'*Ferrari*'),0)