Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 25, 2023 09:10 AM
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?
Solved! Go to Solution.
Jan 25, 2023 09:19 AM
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.
Jan 25, 2023 09:19 AM
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.
Jan 25, 2023 09:25 AM
Thank you for the quick response. This solution works as expected.