+ Start a Discussion

What is the difference between ISNULL and ISBLANK?

I am not sure which function should be used between ISNULL and ISBLANK.


Can anyone describe this for me?


Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 

All Answers


This is very well described in the Help & Training area. Simply search for isblank or isnull to find it.


To put it short, use ISBLANK(). =)

This was selected as the best answer
vijayabakarareddy yarrabothulavijayabakarareddy yarrabothula
Text fields are never null, that means even if you didn't provide any value ISNULL()  function  takes empty as a value.
  so using ISNULL() 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.
  IF(ISBLANK(new__c) 1, 0)   true if if has a value 
  IF(ISBLANK(new__c) 1, 0)    false if it don't have a value