Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HNT_NeoHNT_Neo 

VR for Stage Convert and multiple picklist values and blank field

HI all, 

Trying to figure this VR but no luck. 

Need a VR Rule where it applies to all profiles except system admin, when the Opportunity ID record type =
012d0000000XJyv, and StageName = Conversion, with any values selected from picklist ADO Type = Grow, Mix, or Share, and need to make sure that number field ADO Actual is not blank. 

These parameters should prompt the user to enter data in the ADO Actual field.

  
AND( 
NOT($Profile.Name ="System Administrator"), 
OR( 
RecordType.ID = "012d0000000XJyv"), 
OR(
(ISPICKVAL(StageName, "Convert
(ISPICKVAL( ADO_Type__c , "Grow")),
ISPICKVAL( ADO_Type__c , "Mix"),
ISPICKVAL( ADO_Type__c , "Share")),
AND( 
NOT(ISBLANK(ADO_Actual__c)),
)

 
Ankit AroraAnkit Arora
Am not able to make the exact condition as I don't have those fields in my system, but hope this will help :
  
IF(AND($Profile.Name = 'System Administrator' , RecordType.Id = '012900000002hTL' , Sic != '0') , true , false)

This will check profile should be of System Admin (which you can reverse by using NOT) and recordType.Id should be 012900000002hTL and SIC should have 0 in it.