How to match 2 criteria ?

Hi, im trying to get some help to have a formula to have a summary of a questionnaire, based on a scoring sheet. So the formula will need to match 2 criteria:

1st criteria is to match the question number

2nd criteria is to match the response to the options to yield a target.

i tried index/collect but i realise my 2nd criteria is from a table, hence its not working. Any suggestions ?

Find more posts tagged with

Accepted answers

Samuel Mueller

so something like this should work based on whether they choose low medium or high.

=if(response@row = "Low", index(low:low,match(questionnumber@row, [question number]:[question number], 0)),

if(response@row = "Medium", index(medium:medium ,match(questionnumber@row, [question number]:[question number], 0)),

if(response@row = "High", index(high:high ,match(questionnumber@row, [question number]:[question number], 0))

)))

All comments

Samuel Mueller

@HuiXian So someone is responding low medium and high and you want to return the number associated?

HuiXian

Yap, thats right

Samuel Mueller

so something like this should work based on whether they choose low medium or high.

=if(response@row = "Low", index(low:low,match(questionnumber@row, [question number]:[question number], 0)),

if(response@row = "Medium", index(medium:medium ,match(questionnumber@row, [question number]:[question number], 0)),

if(response@row = "High", index(high:high ,match(questionnumber@row, [question number]:[question number], 0))

)))

HuiXian

Thank you so much Samuel! it worked 😍!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.