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
Antonio Bianco IgnacioAntonio Bianco Ignacio 

Validation Rule for Opportunity Stage Picklist that needs specific Multi-Picklist fields not to be blank.

The situation is, when Stage is equals to "Closed Won" or "Closed Lost" 3 Multi-Picklist must never be blank.

How can I make a rule where the 3 multi-picklist must not be blank, when the values of Stage is Closed (Won & Lost).

i tried multiple attempts with AND, OR, ISPICKVAL, etc.
------
Sample 1:
AND
(
OR
(
ISPICKVAL( StageName , "Closed Won"),
ISPICKVAL( StageName , "Closed Lost")
)
OR
(
ISBLANK(MultiPicklist1__c),
ISBLANK(MultiPicklist2__c),
ISBLANK(MultiPicklist3__c)
)
)
-----
Sample 2:
AND(
NOT(ISNEW()),
ISBLANK(MultiPicklist1__c), 
ISBLANK(MultiPicklist2__c), 
ISBLANK(MultiPicklist3__c),
StageName = 'Closed Won','Closed Lost')
)

Advance thank you for the response.
PuneetsfdcPuneetsfdc
Try these

Sample 1:
IF( OR( ISPICKVAL( StageName , "Closed Won"), ISPICKVAL( StageName , "Closed Lost") ),
     IF( OR( ISBLANK(MultiPickList1__c), ISBLANK(MultiPicklist2__c), ISBLANK(Multipicklist3__c) ), true, false) 
     ,false
)

Sample 2:
IF( OR(ISPICKVAL(StageName, 'Closed Won'), ISPICKVAL(StageName,'Closed Lost')),
    IF( OR( NOT(ISNEW()), ISBLANK(MultiPickList1__c), ISBLANK(MultiPicklist2__c), ISBLANK(Multipicklist3__c)) , true, false)
    ,false
)