Loading
Salesforce now sends email only from verified domains. Read More
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            ISNULL

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            ISNULL

            Determines if an expression is null (blank) and returns TRUE if it is. If it contains a value, this function returns FALSE.

            Use

            ISNULL(expression) and replace expression with the expression you want evaluated.

            Tips

            • Text fields are never null, so using this function with a text field always returns false. For example, the formula field IF(ISNULL(new__c) 1, 0) is always zero regardless of the value in the New field. For text fields, use the ISBLANK function instead.
            • Multi-select picklist fields are never null in s-controls, buttons, and email templates, so using this function with a multi-select picklist field in those contexts always returns false.
            • Don't use ISNULL functions in date/time fields. Empty date and date/time fields always return true when referenced in ISNULL functions.
            • Don't use ISNULL functions in text and lookup fields. Empty text and lookup fields always return false when referenced in ISNULL functions. Use the ISBLANK function instead.
            • Choose Treat blank fields as blanks for your formula when referencing a number, percent, or currency field in an ISNULL function. Choosing Treat blank fields as zeroes gives blank fields the value of zero so none of them are null.
            • Merge fields can be handled as blanks, which can affect the results of components like s-controls because they can call this function.
            • When using a validation rule to ensure that a number field contains a specific value, use the ISNULL function to include fields that do not contain any value. For example, to validate that a custom field contains a value of '1', use the following validation rule to display an error if the field is blank or any other number:
              OR(ISNULL(field__c), field__c<>1)
            Formula Example
            Formula Example 
            (IF(ISNULL(Maint_Amount__c), 0, 1) + ​
 IF(ISNULL(Services_Amount__c), 0,1) + ​
  IF(ISNULL(Discount_Percent__c), 0, 1) + ​
   IF(ISNULL(Amount), 0, 1) +​
    IF(ISNULL(Timeline__c), 0, 1)) / 5

            This formula takes a group of fields and calculates what percent of them are being used by your personnel. This formula field checks five fields to see if they are blank. If so, a zero is counted for that field. A “1” is counted for any field that contains a value, and this total is divided by five (the number of fields evaluated). This formula requires you to select the Treat blank fields as blanks option under Blank Field Handling while the Advanced Formula subtab is showing.

            Validation Rule Example
            Validation Rule Example 
            AND(ISPICKVAL(StageName, "Closed Won"),
  ISNULL(Project_Start_Date__c))

            This validation rule makes the Project Start Date custom date field conditionally required whenever the stage is Closed Won.

             
            Loading
            Salesforce Help | Article