Max Function but with Text

Hello Smartsheet Community: I want the Overall column to look at Issue A, Issue B, Issue C and Issue D and return the highest level. The levels are No Deficiencies, Low, Medium and High. Is that possible with text? See screen shot.

I know I can do this if I made High = 3, Medium = 2, etc. and only had numeric values in the cell using the Max function; however, the people I'm working with need to see the text >.<

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @Melissa Dudley ,

It's a bit lengthy but try:

=IF(MAX(value(left([issue A]@row,1)), value(left([issue b]@row,1)), value(left([issue c]@row,1)), value(left([issue d]@row,1))=1, "Low", IF(MAX(value(left([issue A]@row,1)), value(left([issue b]@row,1)), value(left([issue c]@row,1)), value(left([issue d]@row,1))=2, "Medium", IF(MAX(value(left([issue A]@row,1)), value(left([issue b]@row,1)), value(left([issue c]@row,1)), value(left([issue d]@row,1))=3, "High", "No Deficiencies")

Work?

Mark

All comments

Mark Cronk

Hi @Melissa Dudley ,

It's a bit lengthy but try:

Work?

Mark

Melissa Dudley

Sorry for the delay! It worked great. THANK YOU!

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark

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.