Symbols in Sheet Summary Pane

Hello All,

Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value of the symbols column.

When I use this formula in the sheet summary,

=MIN([Project Health]:[Project Health])

I just get the numerical value 0

Is there a way to get the yellow circle to show instead of 0?

Thank you!

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

Nathaniel Adamian

As far as I'm aware, the MIN function only works for numeric values. Your best bet is probably creating a Health Value column using a formula like =IF([Project Health]@row = "Red", 1, IF([Project Health]@row = "Yellow", 2, IF([Project Health]@row = "Green", 3, 0))). You can always hide this column after setting this as a column formula.

You could then use this formula: =IF(MIN([Health Value]:[Health Value]) = 1, "Red", IF(MIN([Health Value]:[Health Value]) = 2, "Yellow", "Green"))

All comments

Nathaniel Adamian

You could then use this formula: =IF(MIN([Health Value]:[Health Value]) = 1, "Red", IF(MIN([Health Value]:[Health Value]) = 2, "Yellow", "Green"))

Lisa LS Kennedy

Symbols don't have numerical values. They have text values (Green, Red, etc). So you need an IF statement to read the color and assign it value, then you can use the MIN function because you will have "converted" a color to a number.

NRJW53

https://community.smartsheet.com/discussion/comment/480136#Comment_480136

Thank you for the help will give it a shot, but this makes sense!

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.