Supplier assesment
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
-
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!
Answers
-
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!
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!