function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
crlaurrellcrlaurrell 

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")
 
Tushar sharmaTushar sharma
you can use contains method to check that if it contains(*) 
IF(CONTAINS(Product_Type__c, "part"), "Parts", "Service")

more info can be founde here https://help.salesforce.com/apex/HTViewSolution?id=000004749&language=en_US (https://help.salesforce.com/apex/HTViewSolution?id=000004749&language=en_US)
crlaurrellcrlaurrell
CONTAINS does not work with multipicklists.  Can you suggest another solution?