I am trying to create a formula that will auto-assign the [BG Check Phase Assigned to] contact list column with an individuals name based on what country is selected from the [Country - Site] drop-down field.
So if the Country is one of:
Austria
Belgium - Brussels
Belgium - Greenhill
Belgium - Mechelen
Bulgaria
Croatia
Czech Republic
Denmark
Egypt
Estonia
Finland
France - Paris
France - Porcheville
France - Rueil-Malmaison
Germany - Bad Homburg
Germany - Cologne
Germany - Munich
Germany - Munster
Germany - Schwalbach
Greece
Hungary
Ireland - Dublin
Israel
Italy - Milan
Italy - Rome
Latvia
Lithuania
Norway
Poland
Portugal
Romania
Russia - Moscow
Russia - St Petersburg
Serbia
Slovakia
Slovenia
South Africa - Cape Town
South Africa - Centurion
Spain - Madrid
Sweden
Switzerland - Fullinsdorf
Switzerland - Geneva
Switzerland - Zollikon
Netherlands
Turkey
UK - Alnwick
UK - Eye
UK - Edinburgh
UK - Harrogate
UK - Huntingdon
UK - Leeds
UK - London
UK - Maidenhead
UK - Shardlow
UK - Slough, England
UK - York
Ukraine
THEN the BG Check Assigned to contact list field would return XXX name.
Are you able to assist with a formula?