Automated hyperlink URL within anchor text

srasbornik2

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>?

kowal

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?

jmyzk_cloudsmart_jp

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

Received Email Image