Formula Help with Symbols

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!