Scoring Matrix Formula

I'm looking for a formula to act as an automatic scoring matrix. The first part of the score is determined by a dropdown of 3 values (met = 0, not met = -1, and n/a = blank). The next and final part of the score is determined by a symbol color (green, red, and yellow). See image for visuals.



Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!