Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows?
IF the (HIGHEST) Risk Level for rows 14 is "x" THEN action for symbol column
is "low" = blue symbol
is "medium" = green symbol
is "high" = yellow symbol
is "extreme" = red symbol
I currently have a formula to show a RYGB symbol that represents that rows Risk Level, but i want the "Parent" row to show the highest level symbol of the 4 rows.
Example:
Row 2 = Risk Level  LOW
Row 3 = Risk Level  MEDIUM
Row 4 = Risk Level  HIGH
Row 5 = Risk Level  EXTREME
I want Row 1 symbol to show Red Ball Symbol to represent extreme.
If all 4 rows were "Low" then Row 1 symbol will show blue to represent low
Is this possible?
Comments

=IF(OR(RATING2:RATING:5 = 1, RATING2:RATING5 = 2), "Blue", IF(AND(RATING2:RATING5 >= 3, RATING2:RATING5 <= 6), "Green", IF(AND(RATING2:RATING5 >= 7, RATING2:RATING5 <= 10), "Yellow", IF(OR(RATING2:RATING5 = 11, RATING2:RATING5 = 12), "Red"))))
This is what I've tried but isnt working. The # ranges define low, med, high & extreme. I thought going that route might be easier...

Personally instead of low, med, high etc. i used a number system.
In the parent row of risk level, i used this formula
=MAX(CHILDREN([Risk Level]1))
In the first row of the Risk Level Symbol column i used this formula, then dragged it down across the children.
=IF([Risk Level]1 = "1", "Blue", IF([Risk Level]1 = "2", "Green", IF([Risk Level]1 = "3", "Yellow", IF([Risk Level]1 = "4", "Red"))))
this should achieve what you are trying to accomplish.

Thanks Brent! I cant ever remember to use MAX formulas!

Lol no worries. I know its not your ideal solution but glad I could help
You could also do the reverse, and set the colour balls, which then updates the risk level number.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives