It would be great if there were a way for a formula to differentiate between blank and 0 in a number field. Currently, cellname = "" and cellname = 0 both return true, whether the value is "" or 0 .
I understand why this would be the default. It’s like truthy operators in JS ( false == 0 ). But it would be useful if there were an option to circumvent that default behavior, and do a more strict comparison in a particular formula.
Potentially cell = BLANK() would return true for a blank value, but not for a zero value. Currently, equality comparison with BLANK() also returns true for 0 .
Alternatively, it could be done with a new function - something like STRICTEQUALS(a, b) .
... View more