For a specific field “OPPORTUNITY” that I have integrated into Airtable, I get three type of inputs. I need a formula to be able to separate this field in 4 columns.
Input posibilities in “OPPORTUNITY” Field:
- Option 1: Opportunity in TOWN, CITY
- Option 2: Opportunity in STREET, TOWN, CITY
- Option 3: Opportunity in STREET, NUMBER, TOWN, CITY
I need a formula to be able to create the following columns automatically:
Thanks in advance!!