Formula Help with Symbols

Stacie Ferrell

I'm relatively new to Smartsheet formulas and I'm having trouble with the following formula I've tried creating to control the symbol displayed based on the Status selected for the row.

Here's the formula I'm trying with the #UNPARSEABLE error received...

=IF(ISBLANK([Status]8), "", IF([Status]8 = 'Ready for Testing', "Yellow", IF([Status]8 = 'Testing in Progress', "Yellow", IF([Status]8 = 'Passed', "Green", IF([Status]8 = 'Partial Pass', "Yellow", IF([Status]8 = 'Failed', "Red", IF([Status]8 = 'Re-Test', "Yellow", IF([Status]8 = 'N/A', "", ""))))))))

Any help would be appreciated.

Stacie Ferrell

Rookie mistake. I found my mistakes and corrected them

Stacie Ferrell

Rookie mistake. I found my mistakes and corrected them