Home › Forums › Google Sheets & Forms › OR function using reference of text as part of a sentence › Reply To: OR function using reference of text as part of a sentence
This is the only Regex expression I have built – very much trial and error and watching tutorials….
A colleague uses a mail merge spreadsheet to automatically produce and email letters. Unfortunately she doesn’t pick up when there is an error and the merge doesn’t work or send. I use this expression to locate the word INVALID in amongst all the automatic document merge status (ie: Document successfully merged; !!Error Sending Emails: Invalid email: <xxx Email>>; Manually run by [email protected]; Timestamp: Sep 20 2017 9:51 PM) , which results in the cell turning red and the work CHECK flash up.