Formula Help to Add Symbols

jenniferk ✭✭
edited 12/09/19 in Smartsheet Basics

Hey guys - I have a unique request. We use sheets to create project plans for Clients and set up a Column called 'Stoplight Status' using red, yellow, green, etc. colored circle symbols in the cell. Anyone know how to create a formula to sum each category of color? Client is requesting this snapshot. Thanks for any help offered!