Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula to create hyper link with display text defined


I want to be able to clean up/simplify how a link is displayed in a cell. 

Column A: the text I'd like to use for the link display

Column B: the long URL with lots of URL tokens, folder locations, etc..

Column C: a clean, short, hyperlink made from A&B

Example values

A: Profile

B: http://www.domain.com/peeps/folks/active/profile.php&ThisDude=2341235

C: Profile

(don't bother clicking the above link, totally made up)

Is it possible to do this with some formula structure in Column C?

I've tried escaping quotes and building an <a href...></a> structure but it just comes out as text and displays the whole HTML tag.

Thanks for any thoughts. 


This discussion has been closed.