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
If you want a Dynamic filter you will need to make three fields and have three dynamic filters, not one dynamic filter with three choices.

So just make a formula for [Question 1 Taken] with a result value of Yes or No.

Get that working then duplicate the field twice and adjust the formula for the other two questions.