Clickable phone numbers in reports

I need to have phone numbers clickable so we can click a phone number from our phone rather than copy/pasting it. Is there a way to do this? I thought embedding some html code would be an option, but that's not working.

This is the logic I have that pulls the phone number into my report from a cell.

=[Primary First Name]1 + " " + [Primary Phone]1

I thought adding some html like <a href="tel:123-456-7890">123-456-7890</a>

but the quotes screw up the logic.

Websites are automatically clickable so that is working by adding... + "www.google.com" + to the logic string

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!