AnsweredAssumed Answered

Prevent entry of zero only if a date exists

Question asked by dwirony on Aug 28, 2018
Latest reply on Aug 28, 2018 by dwirony

I'm trying to use this formula for "Validated by calculation" in my field "Test Number Entry":

 

If ( not IsEmpty ( Test Date ) ; Test Number Entry > 0 )

 

What I'm trying to achieve:

 

If Test Date is not blank, then Test Number Entry cannot be equal to zero (it CAN be blank, though). If Test Date IS blank, then Test Number entry can be equal to zero or blank.

 

The problem right now is that even if my Test Date field is blank (or empty), it's preventing a zero from being entered in the Test Number Entry field.

Outcomes