Giving an output based on text from multiple selection dropdown

Good Afternoon,

I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date "Finish Start." Both columns are on the same sheet, even though the "Processes" column pulls from another sheet.

Currently, I've been seeing multiple uses of an If/Then formula with "Contains" in it. It seems like the right solution, it's just not giving me a result. This is my current formula =IF(CONTAINS("FAB - Finish", Processes@row, 3, 0))

Find more posts tagged with

Manufacturing

Formulas

Project Management

Groups and Group Management

Workflows in Smartsheet

Accepted answers

Kelly Moore

Hey @Ross Conley

Try this

=IF(CONTAINS("FAB - Finish", Processes@row), 3, 0)

If you have multiple words to add that have different values, delete the zero and parenthesis and add additional IFs after the 3,

Does the formula above work for you?

Kelly

All comments

Kelly Moore

Hey @Ross Conley

Try this

=IF(CONTAINS("FAB - Finish", Processes@row), 3, 0)

If you have multiple words to add that have different values, delete the zero and parenthesis and add additional IFs after the 3,

Does the formula above work for you?

Kelly

Ross Conley

Kelly,

Thank you so much! This fixed it 100%.

When I read the solution, I facepalmed so hard that I fell out of my chair. For those that are rereading it 3 times like I did, the position of your parenthesis ")" are extremely important. I've grown accustom to excel autocorrecting the formulas and didn't realize.

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.