• Antonio Bianco Ignacio
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
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.