Skip to main content

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.


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")

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.

Reply


Terms & Conditions