ValueList with conditional values

[#1]

Hi everybody,

I'm trying to use a Valuelist to fill a Listbox, but I need to add a conditional value to my list.

My formula is something like:

=ValueList('Alpha', 'Beta', If(GetSelectedCount(myField)>0,'Gamma','Delta') )

Does the ValueList allow such an expression? How can I write it?

Tks

A

[jagan · Accepted solution]

Hi,

Create a variable with the expression

vTest = If(GetSelectedCount(F1)>0,'Gamma','Delta')

Now use this variable in

=ValueList('Alpha', 'Beta', vTest )

Check attached file.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Yes you can use like that.

Celambarasan

[#4]

Creating a variable is always the easyest shortcut...

thanks jagan

bye

A