function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Moe ZounMoe Zoun 

Editing current Validation Rules

So I am a novice when it comes to coding and formulas. 

I need to edit this Validation Rule in the opportunity Object with two new business requirements:
  • This Validation Rule shoud ONLY apply to three record types: eHealth, Hospital, and LTC
  • The Validation rule should also apply ONLY when field "Revenue_Type__c" is equal to "New Business" 
The Validation Rule is below:
---------------------------------------------------------------------------

AND( 
NOT(Old_Org_Archive__c), 
Probability >= 0.5, 
OR( 
Numof_Engagement_Ready_Buying_Influences__c = 0, 
of_Strengths__c = 0, 
Num_of_Red_Flags__c = 0 
) 
)

----------------------------------------------------------------------------------

Thank you!


 
Raj VakatiRaj Vakati
Try this
  
AND( 
NOT(Old_Org_Archive__c), 
Probability >= 0.5, 
OR( 
Numof_Engagement_Ready_Buying_Influences__c = 0, 
of_Strengths__c = 0, 
Num_of_Red_Flags__c = 0 
),
OR( 
$RecordType.Name = "eHealth", 
$RecordType.Name = "Hospital", 
$RecordType.Name = "LTC") ,
TEXT(Revenue_Type__c)=='New Business' 
)