Skip to main content
Hello Community - 

 

I do not want my sales users to be able to update the Lead Status to either of these choices without having the Lead Source filled in.  Where is my mistake?

 

AND(

 

ISCHANGED(Status),

 

ISPICKVAL(Status, "Contacted"),

 

ISPICKVAL(Status, "Unqualified/Unsubscribe"),

 

ISPICKVAL(Status, "Qualified"),

 

OR(

 

ISBLANK(TEXT(LeadSource))))
4 件の回答
  1. 2020年7月29日 19:03
    Try this:

     

    AND(

    ISCHANGED(Status),

     

    OR(ISPICKVAL(Status, "Contacted"),

    ISPICKVAL(Status, "Unqualified/Unsubscribe"),

    ISPICKVAL(Status, "Qualified")),

    ISBLANK(TEXT(LeadSource))) 

0/9000