You need to sign in to do that
Don't have an account?
certi_vimal
Difference between ISBLANK and ISNULL
Hi,
I am trying to apply validation rule for asking users to fill First Name for Contact.
I am planning to have ISBLANK formula used. But curious to know, what will happen if ISNULL is used?
What exactly signifies ISBLANK and ISNULL formulaes?
Thanks,
Vimal
ISBLANK
This formula takes a group of opportunity fields and calculates what percent of them are being used by your sales 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). Note that this formula requires you select the Treat blank fields as blanks option under Blank Field Handling while the Advanced Formula subtab is showing.
All Answers
They're pretty much the same, ISBLANK is newer and is the recommened function
ISBLANK
This formula takes a group of opportunity fields and calculates what percent of them are being used by your sales 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). Note that this formula requires you select the Treat blank fields as blanks option under Blank Field Handling while the Advanced Formula subtab is showing.