Help

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

Topic Labels: Formulas
Solved
Jump to Solution
522 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.

Labels