Crossmark✭

Add my vote!

Solution! I wanted to assign numeric values to symbols used in several columns, then tally those to calculate a score. Here's a score for the a 5-star rating field, with no stars equaling the highest value, and more stars equaling a lower value: =IF([Time Involved]182 = "Empty", 6, IF([Time Involved]182 = "One", 5,…

How about formulas based on symbols? Like, "If Field1 has 2 stars, let Field2 = 2".