I have a custom SP list with a handful of non-required numerical fields. I'd like to write a column validation rule for each that would force users to enter any value >=0. Our users will be using Data Sheet View only and editing existing records, not creating new ones (so no Infopath or form solutions).
The rule I've tried is =[Target Field]>=0
This doesn't work because SP treats blanks as 0's. Users could simply skip this field and SP would still see it as "0" therefore passing validation.
Rules
- Users should only be able to enter "0", or any other integer. They cannot leave the column blank.
- Users are only editing existing records in datasheet view. Not creating new ones. Thus, making a field required will not work