Sign Up ›
  • crlaurrell
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

Wildcard or partial values with INCLUDES function

Hello - I have a long multipicklist with many departments ending in (*) - e.g. 'Assessor (*) and am trying to create a validation rule to return an error for departments ending in (*).  However, INCLUDES does not recognize less than the full value.  Is there a solution that does not involve listing each department?  Thanks!

AND(
 INCLUDES(Dept_Division_Compliment_Complaint__c, '(*)'),
  ISBLANK(Email_Date_Time_manual_fwd_cases_only__c),
   Text(Status) = "Closed")
 
2 replies

Wildcard or partial values with INCLUDES function

Hello - I have a long multipicklist with many departments ending in (*) - e.g. 'Assessor (*) and am trying to create a validation rule to return an error for departments ending in (*).  However, INCLUDES does not recognize less than the full value.  Is there a solution that does not involve listing each department?  Thanks!

AND(
 INCLUDES(Dept_Division_Compliment_Complaint__c, '(*)'),
  ISBLANK(Email_Date_Time_manual_fwd_cases_only__c),
   Text(Status) = "Closed")