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!
Answers

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
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!