How to see records without '#' shown in the title?

[wholelottared]

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)

[RsQK · Accepted solution]

Try this:

pick(wildmatch(upper(sr_eventtitle),'*#*','*UPDATE*')+1,sr_eventtitle)

[wholelottared]

This solved it! Thank you so much for your help!!! I need to start using the pick function more often.