Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if(not(wildmatch(Site_Id,'*pr*')),Site_Id, 'Ignore'))
The above returns 'Ignore' whenSite_Id contains pr. I would like to extend it to do that same when Site_Id contains Site_Id mr.
Try
=if(not(wildmatch(Site_Id,'*pr*','*mr*')),Site_Id, 'Ignore'))
I thought I had tried that...apparently not. Thank You!