Validation rule to avoid closing an Opportunity other than today in Salesforce
Validation Rule: AND ( CloseDate <> TODAY(), OR ( ISCHANGED( StageName ) , DATEVALUE( CreatedDate ) = TODAY() ), Probability = 1.00//you can use isClosed = true also )
Tag: Validation Rules in Salesforce
Regular Expression for numbers alone validation in Salesforce
Sample Formula: NOT( REGEX( Miscallaneous__c , '[0-9]*' ) ) Cheers!!!
How to use multiple substitute function in Salesforce?
We have to use nested SUBSTITUTE() methods for multiple replacing of characters. Example: SUBSTITUTE( SUBSTITUTE( Name, " ", "" ) ,"-","" ) In this example, we can remove "-" and ....
Validation rules for Country codes(USA, Mexico, Argentina, Canada, Australia) in Salesforce
Example: OR( AND( ISPICKVAL( Country_Code__c , "USA"),NOT( REGEX( Pincode__c , "\d{5}(-\d{4})?") ) ), AND( ISPICKVAL( Country_Code__c , "MEX"), NOT(REGEX( Pincode__c , "\d{5}")), NOT(REGEX( Pincode__c , "\d{6}")) ), AND( ISPICKVAL( Country_Code__c ....
VLOOKUP in Salesforce Validation Rule
Returns a value by looking up a related value on a custom object similar to the VLOOKUP() Excel function. The field_to_return must be an auto number, roll-up summary, lookup relationship, ....