Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Stars Value

Kenyon Bajus
Kenyon Bajus ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating.

I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers?

Thanks for any help.


Screenshot 2017-06-27 17.10.31.png


This discussion has been closed.