Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can we do sth like this?
if([Data group] like '*Item*',MonthYear)
Hi thanks, but Data Group is still selecting 'Item
'
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