Either I am misunderstanding the purpose of this or I have not stumbled across the correct syntax yet.
I have two sheets (labelled Fire and Medical).
I have a Field labelled EMERGENCY containing only two values (possible values Fire or Medical).
When I select the Fire sheet I want the value Fire in the EMERGENCY field to be selected by default (which would clear the value of Medical) and when I switch to the Medical sheet I want the value Medical in the EMERGENCY field to be selected (which would clear the value of Fire).
So far I have gone to Sheet Properties | Triggers | SheetEventTrigger | OnActivateSheet | AddAction(s)
I have added the action 'Select in Field'
Under Field I have =EMERGENCY
Under Search String Medical
I have tried 'Medical' and "Medical" and various other things I can't recall. The HELP is less than helpful with regard to examples of Search String syntax etc.