GetFieldSelections

[#1]

I Have a listbox with entry's

Cars

Porsche

Volkswagen

Opel

Then i have a table with in the Windowname:

=GetFieldSelections(CARS,', ')

When i select all Cars, the Windowname is called "ALL".

When i select only Porsche and Opel, the window name is called NOT Volkswagen.

I want the window name with the entries i selected!

Instead of all Porsche, Volkswagen, Opel

Instead of NOT Volkswagen Porsche, Opel

[sunny_talwar · Accepted solution]

Try this:

=GetFieldSelections(CARS,', ', 9999999)

[rubenmarin]

Or:

If(GetSelectedCount(CARS), Concat(Distinct CARS, ', '))