Good afternoon, folks! I am working in Leads. I have a picklist called “Lead Status.” The choices in this picklist are:

• Zero
• Open
• Attempted Contact
• Actively Engaged
• Qualified
• Disqualified.

It’s the controlling field for a dependent picklist called “Reason Disqualified.” The choices in that picklist are:

• Did not respond
• Incorrect contact data
• Not interested
• Is consultant or vendor
• Already in pipeline

If "Disqualified" is selected under the Lead Status picklist, I want the user to be required to select one of the choices under the "Reason Disqualified" picklist. The formula I’m currently using is:

AND(TEXT(Status) = "Disqualified",

ISBLANK(TEXT(Reason_Disqualified__c))) 

Any help/guidance is appreciated! 

Good afternoon, folks! I am working in Leads. I have a picklist called “Lead Status.” The choices in this picklist are:

• Zero
• Open
• Attempted Contact
• Actively Engaged
• Qualified
• Disqualified.

It’s the controlling field for a dependent picklist called “Reason Disqualified.” The choices in that picklist are:

• Did not respond
• Incorrect contact data
• Not interested
• Is consultant or vendor
• Already in pipeline

If "Disqualified" is selected under the Lead Status picklist, I want the user to be required to select one of the choices under the "Reason Disqualified" picklist. The formula I’m currently using is:

AND(TEXT(Status) = "Disqualified",

ISBLANK(TEXT(Reason_Disqualified__c))) 

Any help/guidance is appreciated!