I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today.
Check out how this simple script can create links that are dynamic and formatted with the text you want instead of the ugly full URL.
Explainer Video: Loom | Free Screen & Video Recording Software