Formula to create "all that apply" for Knowledge Check Form

Hello Community,

I am currently creating a knowledge check and was wondering if there was a formula to create an "all that apply" type of question. For example:

5. What is on the customer experience call flow?

Smile
Engage
Trust
Own
Listen

This is my broken formula:

=IF(CONTAINS(("Trust", "Smile", “Own”), [5. What is on the customer experience call flow?]@row), "Correct", "Wrong")

Is this something that can be done? Thank you for your help!

Find more posts tagged with

Formulas

Accepted answers

DKazatsky2

Hi @Michael_Selfe ,

Try something like this.

=IF(COUNTM([5. What is on the customer experience call flow?]@row) = 3, IF(AND(HAS([5. What is on the customer experience call flow?]@row, "Trust"), HAS([5. What is on the customer experience call flow?]@row, "Smile"), HAS([5. What is on the customer experience call flow?]@row, "Own")), "Correct", "Wrong"))

This assumes you wanted all 3 items to be checked.

Hope this helps,

Dave

All comments

Paul Newcome

You would need an OR with individual CONTAINS functions.

=IF(OR(CONTAINS("Trust", [5. What is on the customer experience call flow?]@row), CONTAINS("Smile", [5. What is on the customer experience call flow?]@row), CONTAINS("Own", [5. What is on the customer experience call flow?]@row)), "Correct", "Wrong")

DKazatsky2

Hi @Michael_Selfe ,

Try something like this.

This assumes you wanted all 3 items to be checked.

Hope this helps,

Dave

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.