February 17, 200917 yr Not sure of the correct way to do this... Ideally I'd like to have a single field in which I enter text and if I don't enter any text (i.e., it's left empty) it reads "not applicable." I won't even try to describe the ways I've failed... can someone give me some ideas on how to succeed? Please and thanks.
February 17, 200917 yr No calculations required. Use a text field set to auto-enter calculation replaces existing value. Use "Not Applicable" for the calculation. When you enter text, overwrite the auto-entered text.
February 17, 200917 yr Author Holy moly, talk about making a mountain out of a mole hill... which I knew I was doing, yet couldn't stop myself. Thanks so much! I'd be embarassed if I wasn't so relieved to have it resolved so neatly.
Create an account or sign in to comment