Re: Multiple Select or Field only accept certain words?

738 1
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

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?

2 Replies 2

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

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