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)
.