Workflow Failure Due to Copy/Paste Issue from Word or other editors
This issue is typically due
to a syntax error, and in some cases this may not be readily apparent. For
example, if you copy and paste from Microsoft Word, it's possible you could have
incorrect characters.
Sometimes MS Word can convert ascii characters into special characters from other languages. The scenario below can easily be overlooked because the two single quote characters look alike in expression builder with small font.
’Yes’ <------ Quote with special character (causing WF not to trigger) 'Yes' <------ Quote with correct single quote character EXAMPLE Both of the problem Workflows were using incorrect single quote characters, the conditions were most likely created using some type of text editor and then pasted into the Expression Builder. Unfortunately, the "Check Syntax" button doesn't catch the invalid single quotes, but when all the Opportunity "When modified record saved" Workflows are parsed, the single quotes cause a runtime error and all Workflows fail. The best practice when all Workflows of a certain type stop working is to review any new or recently updated Workflows to ensure all syntax is correct.1