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 formula that checks all questions.  If any of the questions have the answer "No" it will give me a "Non-compliance" result, 

and if they are all yes it will give me a "Compliant" result


not sure if this is done with an if statement or not?

6 Replies

  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Hi Geoffery,

    What happens if some select N/A from the drop-down list? Do you want to show something?

    Thanks,
    Gaurav
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Okay. Here you go.

    Create a formula-text field and use the below formula.

    If([Your drop down field]<>"",  If([Your drop down field]="No","Non-compliance", "Compliant"),"")
    Thanks,
    Gaurav
  • 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)