I’m working on a project in Google Sheets where I need to make phone numbers clickable. The goal is to initiate a FaceTime call when clicked on my Mac. I’ve tried a few methods but haven’t had much success.
Here’s what I’ve attempted so far:
=HYPERLINK("callto:" & A1, A1)
=HYPERLINK("tel:" & A1, "Dial Now")
Neither of these seem to work as expected. The first one creates a link, but it doesn’t do anything when clicked. The second one doesn’t even generate a hyperlink.
Has anyone figured out a way to make this work in Google Sheets on MacOS? I’m open to using custom scripts or formulas if needed. It would be really helpful for my project if I could get this working. Thanks in advance for any suggestions!
I’ve encountered a similar issue when working with phone numbers in Google Sheets on macOS. Unfortunately, the ‘callto:’ and ‘tel:’ protocols don’t work seamlessly with FaceTime on Mac. However, I found a workaround that might help you.
Instead of using HYPERLINK, try this custom formula:
=CONCATENATE(“facetime://”, SUBSTITUTE(A1, “-”, “”))
This creates a FaceTime URL. Then, right-click the cell and select ‘Copy link’. Paste the link into your browser, and it should prompt you to open FaceTime with that number.
It’s not a perfect one-click solution, but it’s the closest I’ve managed to get. You might need to adjust it slightly depending on your phone number format. Hope this helps with your project!
I’ve been working with Google Sheets for years, and I’ve found that creating clickable phone numbers can be tricky, especially on macOS. Here’s a method that’s worked well for me:
Use this formula in the cell next to your phone number:
=HYPERLINK(“Google” & ENCODEURL(A1), A1)
This creates a Google search link for the phone number. When clicked, it opens a Google search results page. From there, you can usually find options to call or FaceTime the number.
It’s not a direct FaceTime link, but it’s a reliable workaround that works across different systems. Plus, it gives you the flexibility to choose how you want to contact the number.
Remember to format your phone numbers consistently for best results. This method has saved me tons of time when managing large contact lists in Sheets.