Counting Hearts

We are using a sheet to rate name suggestions. Each employee has their own column and they rate each name suggestion using the heart scale. Does anyone know how to count/sum the total numbers of hearts in a row? Example: I rate a name ❤️❤️❤️❤️❤️, someone else rates it ❤️❤️ - That name suggestion would have a rating of "7".

Thank you!


  • John Jonassen
    John Jonassen ✭✭✭✭

    I think it may be too complex to get it into a single column. So maybe 6 columns following the Heart column, heading them as "One", "Two", "Three", "Four","Five", and "Total"

    Then your formulas will be as follows:

    One: If(Heart1="One",1,0)*1

    Two: If(Heart2="Two",1,0)*2...etc up to five. Then the "Total" would be the sum going across the row. Then you can do a Parent Child for each rate name suggestion to do a roll up of each rating and grand total scores.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!