J. Williams Posted February 17, 2009 Posted February 17, 2009 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.
RalphL Posted February 17, 2009 Posted February 17, 2009 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.
J. Williams Posted February 17, 2009 Author Posted February 17, 2009 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now