Taking Text from One Field and Altering it in Another Field

[LaurenMaine]

Hi there— Grateful for your help in figuring this out.

I have a single select dropdown field in one cell. If a user selects an option in that dropdown field, I'd like the cell next to it to replace the text based on whatever is selected. So in the screenshot, if someone selects "Brown" in the dropdown, I'd like the cell to the right to show just the text "Color Theme D". 

Is there some kind of IF statement or formula I can use in that new cell? Thanks!!

[Jack_Manuel · Accepted solution]

Your best bet would be a SWITCH statement, rather than an IF (if you have more than a couple of options, or might in the future).

The structure for a SWITCH is {something to test} and then pairs of outcomes and actions based on the {something to test} and then a default.

e.g.

SWITCH(
  {Segment Palette},
  'Brown', 'Color Theme D',
  'Blue', 'Color Theme B',
  'Default'
)

So it's test {Segment Palette}, if it's 'Brown', print 'Color Theme D', if it's 'Blue', pring 'Color Theme B', if it's something else, print 'Default'.

[LaurenMaine]

Worked perfectly, thanks!!!