I have a Zap set up like so:
- Trigger: Invitee Created in Calendly
- Then: Create Row in Google Sheet (which sends the client’s info from the Calendly booking to a new row)
One of the Calendly questions is an ability for the user to get text alerts send to their phone for the event, and Calendly automatically places an international calling code in front of the number (ex from the U.S.: +1 800 555-5555).
Problem is, when that field is sent to my Google Sheet, it thinks it’s a formula (since it starts with +). So, it displays “!ERROR” in the field, instead of their phone number.
Anyone know a way I can do a work-around, so that the phone number displays and not an error?
Best answer by sardamitView original