Activity Forums Salesforce® Discussions What is the difference between ISBLANK() AND ISNULL() in salesforce?

  • Manpreet

    Member
    April 6, 2017 at 4:00 pm

    Hi saurabh,

    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

    Thanks.

  • shariq

    Member
    August 1, 2017 at 10:00 am

    Hi Saurabh,

    You can refer to this link.

    Hope this Helps.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos