Selections from an expression in a list box

[tinkerz1]

Hi.

When I write an expression in a list box using a wildmatch, I get both 'MonthYear' and 'Item' selected.

I expected to have just 'MonthYear' selected.

How can I rearrange the below formula to have just MonthYear selected, it messed up my whole sheet.

if(wildmatch([Data group],'*Item*'),MonthYear)

Thanks.

[Anonymous]

can we do sth like this?

if([Data group] like '*Item*',MonthYear)

[tinkerz1]

Hi thanks, but Data Group is still selecting 'Item

'

[SergeyMak]

Hi Neil,

Could you please clarify your logic? Why do you need this "quite strange" from my point of view behaviour?

Regards,

Sergey

P.S.: You can create a separate field in load script eg YearMonth1 and use it in listbox:

if(wildmatch([Data group],'*Item*'),MonthYear) as YearMonth1