Hi! I have a duration field that is sometimes filled out and sometimes not. I’d like to test to see if it’s empty. The problem is that for the meaning of the field, zero is different from empty. Currently if I do something like:
IF( Duration )
If ( Duration = BLANK() )
it returns false for both the field being empty or it being zero. Is there a way to tell the difference in a formula?