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.

  '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.