« Cross Object Formula Fields | Main | Track Field Value Changes »

Validate Salesforce Account


Today, I'll show you a great way to validate an Account based on the following conditions:


  1. If Budget (Number Field)exceeds 10,000
  2. If Decision (Picklist Field) equals Yes
  3. If Timeline (Date field) is not blank


All above conditions must be true for the Custom/Picklist field to be set to "Yes". Here is how to do it: 


  • First, create a custom field (is Account Qualified?)
  • Set the Custom Field type to Formula with Text is output type
  • Copy and paste  the code below:


IF( AND( Budget__c >9999, ISPICKVAL(Decision_c,"Yes"), ISBLANK(Timeline__c)), "Yes", "No")




PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
All HTML will be escaped. Hyperlinks will be created for URLs automatically.