Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I want to have an input box with a predefined drop down list showing values, (e.g. Product1, Product2, Product3).
Entering: Product1;Product2;Product3 in the Contraints tab, listed values of the input box works.
i.e. We see:
Product1
Product2
Product3
However, I want this list to be dynamic, so I have stored the values in a variable vCurrentProductList.
When I have this: vCurrentProductList = 'Product1;Product2;Product3'
and I put =vCurrentProductList in the Inputbox Contraints, listed values - the drop down doesn't work. It shows them all in 1 line:
Product1;Product2;Product3.
How can I use the variable to get a result like this instead:
Product1
Product2
Product3
Thank you.
Hi,
look at the attached.
Regards
ASHFAQ
Try using the following formula:
=Concat( {1} DISTINCT vCurrentProductList, ',' , vCurrentProductList)
It should list them in a column sorted ascending by vCurrentProductList. If the comma for the second parameter doesn't work, try a semicolon.
Try this:
=Concat( {1} DISTINCT YearWeekNumber,'|',YearWeekNumber)
Replace the YearWeekNumber with your column header title name.