Using IF and CONTAINS in one formula

Jess Trial

I am trying to create a formula that returns:

Tolerable if the answer is Low

Tolerable if the answer is Medium

Acceptable if the answer is High

Acceptible if the answer contains Urgent.

I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas.

=IF(Answer@row = "Yes", "Acceptable", IF(Answer@row = "No", "Undesirable", IF(Answer@row = "Not Applicable", "Tolerable", IF(Answer@row CONTAINS "Urgent", "Acceptable))))

I am getting lost at the "CONTAINS" part.

Find more posts tagged with

Formulas

Government

Accepted answers

USB Mike

=IF(OR(CONTAINS("Yes",Answer@row),CONTAINS("Urgent","Answer@row)),"Acceptable", IF(CONTAINS("No",Answer@row), "Undesirable", IF(CONTAINS("Not Applicable",Answer@row),"Tolerable","")))

I believe that should do it. I combined both your variables that yield acceptable.

All comments

USB Mike

=IF(OR(CONTAINS("Yes",Answer@row),CONTAINS("Urgent","Answer@row)),"Acceptable", IF(CONTAINS("No",Answer@row), "Undesirable", IF(CONTAINS("Not Applicable",Answer@row),"Tolerable","")))

I believe that should do it. I combined both your variables that yield acceptable.

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.