I am working on a Zap and trying to use a search formula to be able to find a phone number when there are multiple phone numbers in a cell. These are text strings and not linked records as I know linked records are identified by ID. Forewarning, I'm terrible with crafting formulas!
Here is where I'm at with the formula:
Here is the formula in textual format if you want to play with it:
Basically, what I want to happen is for the search formula to look at a comma-separated list of phone numbers, see if the phone number from Ring Central is in that list and if so, return the number.
Here are some modifications/things I know that need to change:
- Airtable doesn't seem to support ISNUMBER so that will have to be removed
- I actually don't care if the phone number itself is returned. Returning "True" or "False" will work just fine.
Best answer by OpensideView original