Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can ignore 'update' with the following but the “#” doesn’t seem to be working the same way so I can show the first records not the updates
=if(not(upper(sr_eventtitle) like '*Update*' or not(HQ_EventTitle like '*#*')),sr_eventtitle)
Try this:
pick(wildmatch(upper(sr_eventtitle),'*#*','*UPDATE*')+1,sr_eventtitle)
Try this:
pick(wildmatch(upper(sr_eventtitle),'*#*','*UPDATE*')+1,sr_eventtitle)
This solved it! Thank you so much for your help!!! I need to start using the pick function more often.