Update a field when a different field is selected is a different column

[jesspeck]

Hi! I use Airtable for tv title tracking and I'm trying to see if it's possible to update a field ("Distribution Rights") when a separate field ("Distrbution Rights Details") is selected. Example listed below:

• When "EXPECTED: All Media Worldwide" is selected in the "Distribution Rights Details" field, populate "Distribution Rights" field as "Global Expected"

Is this automation possible? If so, would it be possible to add additional options (when All Media Worldwide is selected, populate Global in Distribution Rights)?

[TheTimeSavingCo]

Does this look right? 

SWITCH(
  {Distribution Rights Details},
  'EXPECTED: All Media Worldwide', 'Global Expected',
  'All Media Worldwide', 'Global in Distribution Rights'
)

Link to base