Formula to Return Symbols

I am utilizing a formula to return symbols based on a inputs from another sheet. Here is the formula:

=IF([Status Indicator]@row = "1", "Yellow") + IF([Status Indicator]@row = "2", "Green") + IF([Status Indicator]@row = "3", "Red") + IF([Status Indicator]@row = "4", "Blue")

The yellow and green symbol are showing as intended, but the Red and Blue symbols aren't showing and returning the following values: 0Red and 0Blue.

I checked to make sure I was using the right column type. Any suggestions on how to fix? Thanks.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If it is only supposed to be showing one color at a time, you would want a nested IF statement instead.

    =IF([Status Indicator]@row = "1", "Yellow", IF([Status Indicator]@row = "2", "Green", IF(.................

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!