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
(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.