Hi SF Community,
I'm struggling with an Opportunity Validation Rule where I'm unable to make to make 2 picklists required after moving an opp from 75% (Decision) -90% (Procurement). Does anyone have any sample syntax that could help me? This is what I have so far:
Probability > 74 AND (Carrier_Fees__c = ISNULL) AND (Required_Data__c = ISPICKVAL(picklist_field,Medical, Rx, Onsite clinic, Biometric Screening, Wellness Programs,Payroll,Workers Compensation, Stop/Loss)
The Carrier Fees field is either a Yes or No. The Required Data is a picklist field with Medical, Rx, Onsite clinic, Biometric Screening, Wellness Programs, Payroll, Works Compensation, Stop/Loss as ths possible fields. It will at a minimum be one of these fields for the Required data submission.
Any help would be greatly appreciated!! Thank you in Advance!
-Drew
If Only Required_Data__c is an MSP, use this instead:
AND(
Probability > 0.74,
OR(
ISBLANK(TEXT(Carrier_Fees__c)),
ISBLANK(Required_Data__c)
)
)
