Default selection in a expression list box

Mon, 08 Sep 2014 22:57:08 GMT

Hi,

I got a list box with this expression

if(Aging < 1, 'Current', if (Aging >=1, 'Later'))

Now i need to default select one of these options in listbox when sheet opens up...

I know i need to "Select in Field" trigger "OnActivateSheet" but i am not sure what should i put in the field?

How to do that?

Saurabh

Re: Default selection in a expression list box

danieloberbilli — Mon, 08 Sep 2014 23:20:09 GMT

I would rather script an additional field with the values Current and Later (see example with field called Aging Status)

Kind Regards

Daniel