If a cell contains three specific values, assign a numerical number

Hello community,

I'm relatively new to Smartsheet and need some help with a formula. I am trying to have a number appear in a helper column when three specific options from a multi-select drop down list are selected in the same cell.

I have included a screenshot of an example of what I am trying to do. If Option 1, Option 2, and Option 4 are selected in a cell in the column titled Question 3, then I need the number 1 to appear in column 3 HELPER in that row.

I'm using the function =IF([Question 3]@row = "Option 1", 1) when it is just one value selected, but not quite sure what to do when three specific options are selected. Is there a variation of IF(AND) that can work for this scenario?

Any help with this would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

Darren Mullen

@iligenza

=IF(and(has([Question 3]@row, "Option 1"),has([Question 3]@row , "Option 2"),has([Question 3]@row , "Option 4")), 1)

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.