I have two different fields that I would prefer to combine into one so I can use it as a default filter more easily. I am struggling to get it to work and could use some advise. Here is the basic formula in each field:
Question A Status= If(([Question A])<>"","Question A Only", "Question A Not Answered")
Question B Status= If(([Question B])<>"","Question B Only", "Question B Not Answered")
Is it possible to combine these into one formula (I've tried but it is not working for me)? If Question A or B are blank I really do not need a value -- I would rather it not auto-fill "blank", but I can't seem to get it to ignore it. Any help is appreciated. Should I be using Case instead of IF statement?
Thanks in advance!