How to Create URL to Call a Number in Facetime
Learn how to create a URL to call a number in FaceTime directly from Google Sheets using a simple hyperlink formula. This tutorial covers various formats for phone numbers and how to troubleshoot common errors.
I'm going to show you how to create a URL to call a number in FaceTime from Chrome. This is really cool. If you have a bunch of phone numbers and you're trying to call people from your computer from Chrome, and you have them in a Google Sheet, we can create this telephone number hyperlink that basically, watch, you can copy this. Create a new tab and put in the number and you can open FaceTime and call them. This is super awesome. If you're trying to call people from your sheet and needed to open in FaceTime. So how do we do this? I'm going to show you really quick. We have phone numbers. They can be all sorts of different variable formats. Here's plus in front of it. Some numbers are just the number without the plus. We're going to equal, I'm going to use hyperlink as the formula . We're going to put T E L colon. Embed a Number in a Website from a Google Sheet Make It Easier For Others To Use Your Google Sheets Embed a Number in a Website from a Google Sheet How to Fix Phone Number Formula Parse Errors in Google Sheets
In quotes, and then use an ampersand and select the range where our phone number is. This allows us to immediately have this telephone, basically URL, and we can click and drag this down and we have all of our telephone numbers now in this TEL format . If however you want to just get this text here, and let's say we have a plus sign in front of all of these numbers, we can actually else. Let's delete that. Let's select these two ones that have the plus sign. Command F. I'm going to click the three buttons here for more options. And I'm going to find every plus sign and replace it with T E L colon plus sign. So we're keeping that plus sign but we're just adding T E L colon here on that specific range . We are replace all , done, and now we have T E L, and again we can copy paste Make Your Headers Useful How to Fix Phone Number Formula Parse Errors in Google Sheets
that into Chrome and it'll open FaceTime. Very, very simple. If, however, you're getting some kind of error , like if we have just a plus sign here. And you get this like equal sign. That's going to be because Google Sheets thinks that plus sign is a addition. And it's a bunch of numbers, so it thinks it's just a formula . So how do we get this equal sign? Maybe you copy and pasted them here or you have some formula parse error . How do we get that equal sign to turn into a plus sign or even T E L? Same, command F to find. Click the three options. We're going to select equals. We're going to find that. We're going to replace with a single quote plus sign and we want to select just the specific range we're in for now. The key is here. We also want to search within formulas. Google Sheet Basics - The Absolute Basics Your First Formula in Google Sheets How to Fix Phone Number Formula Parse Errors in Google Sheets
Click replace all . Replaced one instance. Done. And you can see it here. So if you have to add a plus sign in front of it. Just make sure you add a single quote here. And if you want to use that telephone URL, just add T E L colon plus sign. There you go. That's how to create a URL to call numbers in FaceTime from Google Sheets of all things. Creating a Custom URL Link for Your Spreadsheet Extract URLs from Google Sheets Embed a Number in a Website from a Google Sheet How to Fix Phone Number Formula Parse Errors in Google Sheets