I want to create a AVERAGE formula using 3 columns that use the single select function. See attached image.
Solved
Use number(s) from Single Select in calculation formula to average the score
Best answer by kuovonne
Welcome to the Airtable community!
Even though the single select values look like numbers, they are not numbers to Airtable. You need to convert them to number in your formula.
AVERAGE(
VALUE({Evaluator 1 score}),
VALUE({Evaluator 2 score}),
VALUE({Evaluator 3 score})
)
You will also probably want to adjust the formatting options for the formula field to show the number of decimal places you want.
+29Welcome to the Airtable community!
Even though the single select values look like numbers, they are not numbers to Airtable. You need to convert them to number in your formula.
AVERAGE(
VALUE({Evaluator 1 score}),
VALUE({Evaluator 2 score}),
VALUE({Evaluator 3 score})
)
You will also probably want to adjust the formatting options for the formula field to show the number of decimal places you want.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.