Supplier assesment

Sana Salem Constant

Hello,

I developed a questionnaire for supplier evaluation, the score obtained from this form will feed at one point my supplier score card. What I want is for the form to be automatically scored regarding the response received by the supplier: for example if Question 1 is "one of the proposition" ( from a column with 3 options in a drop down list), return 5 in the cell if true, 0 if false), so here what I tapped :

• =IF(OR({Supplier Questionnaire-log Range 1} = "Quality requirements", {Supplier Questionnaire-log Range 1} = "Environmental requirements", {Supplier Questionnaire-log Range 1} = " Regulatory requirements"), 5, 0)

But it get " Invalid Operation".

Can anyone tell me where I am wrong?

Thank you in advance.

Sana

David Joyeuse

Hi @Sana Salem Constant

Problem in your formula lies in your OR formula, the statements cannot be ranges, you have to test cells, not a full range.

Can you share us some screenshots of your form/sheet with no sensitive data or confidential ones on it so we can give you a better hand?

Hope it helped!

David Joyeuse

Hi @Sana Salem Constant

Problem in your formula lies in your OR formula, the statements cannot be ranges, you have to test cells, not a full range.

Can you share us some screenshots of your form/sheet with no sensitive data or confidential ones on it so we can give you a better hand?

Hope it helped!

Sana Salem Constant

Hello David,

Thank you, I figure it out with your answer, I selected cells instead of column and it worked.

Thank you for your help.

Sana