Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 22, 2022 11:32 AM
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!
Sep 22, 2022 12:31 PM
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: