Help

Use number(s) from Single Select in calculation formula to average the score

Topic Labels: Formulas
Solved
Jump to Solution
1496 1
cancel
Showing results for 
Search instead for 
Did you mean: 
B_Michael_69
4 - Data Explorer
4 - Data Explorer

I want to create a AVERAGE formula using 3 columns that use the single select function. See attached image.
Screen Shot 2021-08-03 at 10.37.38 AM

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.