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

CarolDF

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!

jmyzk_cloudsmart_jp

Hi @CarolDF

=IF(RYG@row = "Green", 5, IF(RYG@row = "Yellow", 3, IF(RYG@row = "Red", 0)))

jmyzk_cloudsmart_jp

Hi @CarolDF

=IF(RYG@row = "Green", 5, IF(RYG@row = "Yellow", 3, IF(RYG@row = "Red", 0)))