Currently, BLANK() function returns true even for the cell where the value is 0 (zero). It will be more useful if the BLANK() function returned true strictly if the cell is empty.
BLANK() should return true ONLY for the actual "blank" situation
+4This topic has been closed for replies.
+21I prefer to avoid BLANK() entirely. It’s easy enough to check for an empty field by just using the field reference:
IF({Field Name}, ...
Except for fields containing numeric values, that will return true for any non-empty field, and false for any empty field. For numeric fields, use this:
IF({Field Name} & "", ...
That will convert the field contents to a string, where a non-empty string is equivalent to true, and an empty string equates to false.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.