Help

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

Changing multiple select options via formula

Topic Labels: Formulas
Solved
Jump to Solution
326 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting into formula’s a bit more as a novice lately, but struggling to get this one right. Anyone able to help me out on this one?

What I want is to change the Multiple Select Field as per below.

  • small instead of s
  • average instead of a
  • tall instead of t

Was thinking in the direction of wrapping the exiting formula in a Switch( ) to change the select options small, average and tall to s, a and t for the the output.

image

1 Solution

Accepted Solutions

Because you have a multiple-select, a SWITCH() isn’t the way to go. You can use nested SUBSTITUTE().

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE( {sat}, 
"a", "average"),
"s", "small"),
"t", "tall")

See Solution in Thread

2 Replies 2

Because you have a multiple-select, a SWITCH() isn’t the way to go. You can use nested SUBSTITUTE().

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE( {sat}, 
"a", "average"),
"s", "small"),
"t", "tall")

Doesn’t disappoint. As expected of course. I’m learning bit by bit by this.