May 5, 2020
How do I make numbers in google sheets click to call?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (2)
May 6, 2020
HYPERLINK() is the function to create links. But it doesn't support (or offers)
tel: or call: link types.The supported link types are
http://, https://, mailto:, aim:, ftp://, gopher://, telnet:// and news://.You can find more info here - https://support.google.com/docs/answer/3093313?hl=en-GB
***WORKAROUND***
Then the next option is using any supporting add-on that you can find by searching the menu Add-on->Get add-ons.
But without installing any add-on it's possible to make numbers in google sheets click to call.
You just need to hyperlink to a third-party URL (Source: https://www.labnol.org/internet/google-sheets-phone-numbers/29228/)
Please find the step-by-step instructions below.
DISCLAIMER: Use it at your own risk!
Steps:
1. Enter the phone number as a text string (starting with a single quote).
2. In cell B1, insert this formula.
=HYPERLINK("https://ctrlq.org/call/"&A1, "Call Google Support")You may be able to click this link in cell B1 to call.
You might then want to make the Google Voice dialer as default dialer. Maybe this thread will help.
See if that helps?
Best,
Prashanth KV
Last edited May 6, 2020
May 6, 2020
if you're able to use a smartphone with Sheets installed to make any of the calls, I've started to notice that if you "click" and hold (as if you were trying to copy/ paste/ w/e) a cell, there may be a popup (at the front of the normal options) to try opening the cell contents in an external app (Maps/Chrome/Phone etc). You'd still need to change the default phone app though else it will take you to the standard call app.