Automatic hyperlinks

Zsolt
Zsolt ✭✭✭
edited 10/13/21 in Formulas and Functions

Hi,

I've seen this topic going on since 2017. Is there a way now to turn off automatic hyperlinks (even if they are not hyperlinks)? If not, would it possible to give us a function that just simply turns a hyperlink into plain text? It's a clumsy workaround but at least it's a workaround.

Has anyone else figured out how to deal with hyperlinks?

Thanks!

Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Zsolt

    Are you referring to adding text into Smartsheet, then the cell turns the url into a hyperlink?

    Ex.: https://community.smartsheet.com/

    If so, this is due to the https::// or www. at the beginning of the URL. You can turn this into plain text by either manually removing that part of the url, or we can strip it out with a formula in a helper column. For example, if it's because all your text has https://, we can strip it out like so:

    =SUBSTITUTE([Text Column]@row, "https://", " ")


    If I've misunderstood what you were looking to do, it would be helpful to see screen captures of your current set-up and sheet. Please also feel free to let the Product team know about your use-case and request by filling in this form, here.

    Thanks!

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!