Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Automated hyperlink URL within anchor text

    ✭
    edited 02/24/25 in Formulas and Functions

    In Smartsheet we are looking to build the following automation:
    1. Team A fills out a form with client info
    2. After form is entered, an email is sent to Team B
    3. Team B logs onto the Sheet, and adds a one-time login URL to the corresponding client row in Column A
    4. Team B clicks a checkmark under the "Send Email" checkbox column, and an email with the login URL is sent to the client

    The login URL is extremely long and looks unprofessional. While, yes, Team B could just click CTRL + K or find the Hyperlink button on the right click context menu, it does feel like a very easy opportunity to automate it for consistency's sake.

    Is there really no way to mirror Excel's =HYPERLINK("https://www.example.com", "Link Text"), or incorporate markdown like syntax like [Text](https://www.example.com), or allow for HTML editing within the automation body like with href="https://www.example.com">Link Text</a>?

    Tags:
    · Share on FacebookShare on Twitter

    Answers

    • Overachievers Alumni

      hi @srasbornik2,

      I wish I had a better response for you but the hyperlinks in Smartsheet are pretty difficult to work with and as for now it only works if you add in the cell hyperlink etc. maybe you can put this in the new ideas of this community?

      Tomasz Kowalski

      The Real Smartsheet Enthusiast

      Is there anything else we can help you with? - book your time.

      MASA Consult - Your Aligned Smartsheet Gold Partner

      Find us on LinkedIn & Check our Smartsheet Solutions!

      Tag my name: @kowal if you want me to respond :)

      · Share on FacebookShare on Twitter
    • Community Champion

      Hi @srasbornik2 ,

      Using Power Automate, you can create an automated workflow that checks the checkbox column in Smartsheet, retrieves email content including the login URL and formatted display text, and sends an HTML-formatted email to the client with a properly formatted hyperlink.

      You can automate the same using Google Apps Script, too.

      Image of Power Automate Flow

      image.png

      Received Email Image

      image.png
      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions