Creating a link from columns

I like to create a “whatsapp” link based on the following
I have a column called “Phone” it used the US numbering phone # (555) 555 - 5555

i want to create a whatsapp link in which the phone number is stripped of its formatting and adding the digit 1.

In addition to create the whatsapp link will need:

So in this case it will be https://wa.me/15555555555

This data in this whastapp column will be automatically added based on the phone number entry.

You can set this up with a filter in Zapier — no problem. Feel free to message me if you need help: +1 305-680-3367

Thanks for the reply but why not just do s formula / script?

Sign up