Average multiple switch formula columns

I have a table with multiple single select columns. Each single select column generates a numerical value, through a switch formula. I want to average the numerical values for each switch formula column. When I average the columns out now, I get back NaN.

Here are examples of my switch formula columns:

Is there a way to do this?

Your switch formulas are return strings instead of numbers. Remove the quotes around the numbers in the switch formula so that the formula returns numbers.

SWITCH({Length},
  'Less than 1 minute', 1,
  '1-3 minutes', 2,
  '3-5 minutes', 3,
  '5-7 minutes', 5,
  '7+ minutes', 8
)
1 Like

This Airtable newbie is very grateful that it was a quick fix - thank you! :slight_smile:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.