Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Creating a Contains formula for location

596 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniella_Castel
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi!

Im trying to create a formula from one column where all of our members manually inputted their location (NYC, LA, SF) and input it to another column where I have them as multi select. So ideally any record that contains New York City will fall under NYC, Los Angelas will fall under LA.

Has anyone done something like this before?

TIA!

1 Reply 1

Hi @Daniella_Castellanos,
Welcome to the Airtable forums :slightly_smiling_face:

Unfortunately this isn’t something you can do with a formula. Formula’s are a type of field, so the formula resides in its own field (column). The formula can affect what its own cell displays, but the formula cannot change the contents of another field.

What you are wanting to do sounds like something that will either have to be handled by:

  1. Automations
  2. Some form of manual transferring (for example, a formula field that converts the user input into text resembling your multi-select options, which you then copy-paste over into your multi-select field, or use a Batch Update Extension to copy over)