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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!