Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

rating to number

Topic Labels: Community
1146 2
cancel
Showing results for 
Search instead for 
Did you mean: 
andrewn
4 - Data Explorer
4 - Data Explorer

I am hoping someone can help answer this basic question.

We have a survey where our athletes answer using a ranting system. I want to take the rating once in airtable and assign it a number value. 1 star = 1, 2 stars = 2, 3 stars = 3, 4 stars = 4, and 5 stars =5 so I can total.

Is this an easy thing to do or do I need to get the data into a number before it hits airtable?

2 Replies 2
Marquetry_Tech
4 - Data Explorer
4 - Data Explorer

Hi, 

Here are a couple options that might work for you.

Airtable already assigns numbers to stars so by creating a summary table whereby you link to each rating record you can then create a sum formula of those records that will total the star rankings.

Marquetry_Tech_1-1702049189520.png

You can see below that if you did want a separate column of numbers, one way would be the IF formula.  

Marquetry_Tech_0-1702048340668.png

 

Hi,
I'm sorry, but I would consider such formula as a very bad practice.
In the case when you want to avoid zero values, you can do IF(Rating,Rating)

Alexey_Gusev_0-1702051934544.png