Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
8 years ago

formula compilation help

I just need some direction on how to compile an if type formula: I have a questionnaire with a list of approx 20 "Yes" "No" "N/A" options in each (drop down list) I want to create a quick formul...
ChristaFauber's avatar
ChristaFauber
Qrew Member
8 years ago

I do something like this assigning a numeric value to the responses and add them together.  Then set up a rule to update your field to compliant as long as this formula field = the total number of questions.


If([Question1]="No",0,1)
+If([Question2]="No",0,1)
+If([Question3]="No",0,1)
+If([Question4]="No",0,1)
+If([Question5]="No",0,1)
+If([Question6]="No",0,1)