call
📞 Call
Smart Way to Make Phone Numbers Clickable in Google Sheets
The problem
HYPERLINK() is the function to create links, but it doesn’t support (or offers) tel: or call: link protocoles.
Workaround
First option
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.
BEST option
You can use Gsheeets Call page which contain nothing else but the redirection to the tel protocol, you can check code here.
Demo
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
How to use
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")
Authors
- Mehdi Chaouch - Maintainer -
License
This project is licensed under the MIT License - see the LICENSE details.
Credits
Inspired by
This was designed with the inspiration from this fine folks: