The keywords “Rough-In” and “Fit-Off” can appear in the email subject or body. The saved search to list emails where keywords “Rough-In” and “Fit-Off “are present.
Select Formula(text) in criteria and give the below formula.
CASE WHEN UPPER({custrecord_cslo_bie_subject}) LIKE '%ROUGH IN%' OR UPPER({custrecord_cslo_bie_subject}) LIKE '%FIT OFF%' OR UPPER({custrecord_cslo_bie_email_body}) LIKE '%ROUGH IN%' OR UPPER({custrecord_cslo_bie_email_body}) LIKE '%FIT -%' THEN 'T' ELSE 'F' END
