Is it possible to hide 2 items in a list box

[Anonymous]

Hello!

Is it possible to make 2 items invisible in a list box?  .... There are 5 items in my list box and I only want to show only 3 items and hide the other 2 items.

Thank You!

[iktrayanov]

Use expression like

If(match(YOURFIELD,'VALUE YOU WANT TO SHOW 1', 'VALUE YOU WANT TO SHOW 2','VALUE YOU WANT TO SHOW 3') > 0,YOURFIELD)

[Anonymous]

Hi! Ivan,

I tried adding the formula in the expression box but  the value I want to show were just added (makes a new column)  without losing the 5 original values...

So my  field showed up as

A  A

B  B

C  C

D  -

E  -

Instead of

A

B

C

Tks.

[Anonymous]

Attached is an example.

=IF(MATCH(Alphabet,'A','B','C'),Alphabet)

[iktrayanov · Accepted solution]

Please see attached

[Anonymous]

Ivan,

Thank you!  This one works now...I actually placed the formula in the expressions tab instead of the general tab...

Tks..

[Anonymous]

Hi! Ivan,

I have a follow up question with the same scenario...What about if I want to filter the list of Fiscal Years in a list box?   I have a bunch of Fiscal Years listed from 2004-2015...And I only want to show the current Fiscal Year 2014 and forward of available.

Tks.

[iktrayanov]

Try

If(FiscalYear>2013, FiscalYear)

If that Does not work you can try

=If(match(FiscalYear,'2014','2015')>0,FiscalYear)

[iktrayanov]

If you don't want the current year hard coded try

If(FiscalYear>=year(today()), FiscalYear)

[Anonymous]

Ivan,

Yes, this is what I want...I don't want it hard coded so I don't have to update every new year comes.

Thanks...