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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!