Forum Discussion

SamanthaStanley's avatar
SamanthaStanley
Qrew Member
4 years ago

Formulas

I have a form that shows 3 questions where the answer options are all Yes/No. If the question is answered as "Yes" I want it to be counted as one error, and "No" is equal to no errors. I have a field for "Total # of Errors" and a field for the %. How would I create the formulas to show the total number of errors?​

------------------------------
Samantha Stanley
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    I would probably do something like this:

    var number one = IF([question 1]="Yes",1,0);
var number two = IF([question 2]="Yes",1,0);
var number three = IF([question 3]="Yes",1,0);

$one + $two + $three​


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • SamanthaStanley's avatar
      SamanthaStanley
      Qrew Member
      4 years ago
      That worked, thank you!

      ------------------------------
      Samantha Stanley
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        4 years ago
        Can you show your formula?

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quickbase Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------