InputBox - Predefined Values with Commas

[#1]

Hi Everyone,

So I created an InputBox and chose to have predefined values with a drop down - it worked perfectly except a few of the values in Categories have commas in them so the drop down is separating them.

Any ideas?

Thanks,

J

Expression: 

=concat(distinct Categories,',')

Categories:

"Shirts", "Pants, short", "Pants, long"

What I'm getting in the drop-down:

Shirts, Pants, short, long

[SergeyMak]

Hi

Try to use other symbol in the Concact

OR replace ", with . like (=concat(distinct REPLACE(Categories,'",','".'),'.'))