Multiple Select or Field only accept certain words?

[Lost-Merovingia]

I have a field that should be one of 4 items. But because my automations are messed up - mainly from zapier parser - they gave me more data than they should.

It’s supposed to take a name, not the whole paragraph. Is there a way that I can make a formula, to say "if the field contains , just output mary, and delete the rest?

[TheTimeSavingCo]

Yeah, a combination of IF() and FIND() should work for you, and then use that output for the automation to update the multiple select field I guess?

Here’s the formula documentation

[Lost-Merovingia]

Actually - I’m just going to try to find a better system than the Zapier Parser … it’s awful. Thanks.