Help with an IF statement when using two fields

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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!
Photo of Pro Survey Solutions

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Please provide the desired result if the user enters:

Q1 only
Q2 only
Q1 and Q2 both
nothing
If the user answers only one or the other then it would display:

Q1 only -- would only display Question 1 answered 
Q2 only -- would only display Question 2 answered

If neither question answered it should be excluded.
If both questions answered, it is already covered by the above when both options are selected in the report.  Does this make sense?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Try this
List("\n",
IF(Trim([Question A])<>"", "Question A Answered"),
IF(Trim([Question B])<>"", "Question B Answered"))