
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 01:46 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 04:08 PM
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")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 04:08 PM
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")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2022 11:41 AM
Doesn’t disappoint. As expected of course. I’m learning bit by bit by this.
