Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
Solved
Jump to Solution
581 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.