Supplier assesment

Options

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!