Leveraging Formula Fields - Converting a Single select value to a numeric value for use in a cal

[KCoates]

Requesting some guidance here. I'm new to Airtable and have read some documentation but have not fund any examples similar to my use case. 

I have a single select data field that I need to convert each selection items to a numeric value that can then be leveraged in a calculated field that will score an item in the table.

How can this be done in Airtable?

[kuovonne · Accepted solution]

It depends on your single select choices.

One way is to use a SWITCH formula: 

SWITCH( {single select field name},
  "choice A", 1,
  "choice B", 2,
  "choice C", 3
)

Another option works if the single select value looks like a number:
VALUE({single select field name})

Sometimes a combination approach also works and there are also interesting things that can be done by combining functions. However, these all depend on the actual choices.

[KCoates]

Thank you for the quick response.  This solution works as expected.