• Rashmi Tyagi 10
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi all,

I would need to validate differents options. If Lead Status is "Unqualified", Reason rejected must be filled but if lead status is open or pending or
qualified, the reason rejected must not be filled. Here is my code. Any help?
AND( 
ISPICKVAL(Status ,"Unqualified"), 
ISBLANK( ReasonRejectedByCommercialPlanning__c ))
OR
ISPICKVAL(Status ,"Open")
NOT (ISBLANK( ReasonRejectedByCommercialPlanning__c ))
||
ISPICKVAL(Status ,"Pending")
NOT (ISBLANK( ReasonRejectedByCommercialPlanning__c ))

Many thanks
  • March 02, 2017
  • Like
  • 0