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

Comments

This discussion has been closed.