Is there a way for the automation to perform the action based on the response in a certain field e.g. if the response in the Gender field is ‘Male’ the record should be created on one table and if it is ‘Female’ then the record should go on another t...

I have an address field. I would like a formula (probably using SWITCH) to say that if the address contains “London” or “Chingford” or “Romford” the Location field should say London or if it contains “Hale” or “Stockport” or “Bury” the Location field...