Forum Discussion

AmptivaInc's avatar
AmptivaInc
Qrew Cadet
7 years ago

Need help with a formula field -- Trying to populate a new field based upon whether or not the original fields are blank or not.

I am trying to create a new field that can be used as a filter for a report.  The issue is this -- I need to create a field that enters a value based on Question 1, Question 2, or Question 3 being ans...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try this

List("\n",
IF(Trim([Question 1])<>"","Question 1 taken"),
IF(Trim([Question 2])<>"","Question 2 taken"),
IF(Trim([Question 3])<>"","Question 3 taken"))

The result would be a vertical list like 

Question 1 taken
Question 3 taken

If they answered questions 1 &3.

The report filter could use the contains as a filter like 

where [Questions Taken] Contains 1