Input Box with pre defined listed values - formula instead of written list

[#1]

Hi,

I have an input box that works fine with a predifined list of values typed in e.g.

;Very Easy;Somewhat Easy;Undecided;Somewhat Difficult;Very Difficult

However im trying to add a forumla that has these predifined values stored in a field called 'Answer Options'. The formula picks up the values correctly which but doesnt make them appear as a list. My formula is:

=ONLY({1<[Question Number]={"1"}>}[Answer Options])

Any help?

[Oleg_Troyansky]

Hi,

function Only() can't be used for multiple values - it can only return a single available value. The syntax for your case is this:

=concat({1<[Question Number]={"1"}>} [Answer Options], ',')

You may wonder why do we use a coma instead of a semi-colon (I'm wondering, too), but this is the way it works - the list is presented correctly with the coma, and incorrectly with semi-colon, for some reason...

cheers,

[#3]

Hi Oleg,

Thanks for your help. But the list still comes up as 1 value.

Perhaps a look at the data sheet that feeds the field 'Answer Options' explains how my data is organised. Im trying to use the box in red from the formula.

Any ideas?

[Oleg_Troyansky · Accepted solution]

try replacing semi-colons with commas and see if it works

[#5]

hi oleg excellent advise

many thanks

[Oleg_Troyansky]

let me take back what I said before about only() - in your case, you already combined multiple values into a single field, so the use of only() was totally appropriate...

I just tested the list with commas, and it works just fine. See attached