Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try to use other symbol in the Concact
OR replace ", with . like (=concat(distinct REPLACE(Categories,'",','".'),'.'))