Can I use an if statement to return a numeric value based on red yellow green symbols

CarolDF
CarolDF ✭✭
edited 06/14/23 in Formulas and Functions

I am trying to create a scorecard and would like to return a numeric value based on symbols (green = 5, yellow = 3, red = 0). Is that possible? Formula help would be amazing!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!