Forum Discussion

SamanthaStanley's avatar
SamanthaStanley
Qrew Member
3 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 ...
Formulas and functions
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
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
3 years ago
That worked, thank you!

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

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