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?
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.