π Call
Smart Way to Make Phone Numbers Clickable in Google Sheets
HYPERLINK() is the function to create links, but it doesn't support (or offers) tel: or call: link protocoles.
As describe in Google Docs Editors Community, you can use an add-on or use labnol third-party URL without knowing what is done with you info.
You can use Gsheeets Call page which contain nothing else but the redirection to the tel protocol, you can check code here.
Need some demo, check those links:
- White House (US) - +1 202-456-1111
- PM Office (India) - +91 (11) 2301 2312
- Google Support (US) - +1 855-836-3987
- Microsoft (India) - 1-800 102 1100
- 10 Downing St (UK) - +44 (20) 7925 0918
You just need to concatenate you phone number cell (here A1
) with https://gsheeets.github.io/call/
via an HYPERLINK function like this:
=HYPERLINK("https://gsheeets.github.io/call/"&A1; "Call our support team")
This project is licensed under the MIT License - see the LICENSE details.
This was designed with the inspiration from this fine folks: