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

Find more posts tagged with

Accepted answers

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!

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.