Mailto: in a sheet

Saul C.

I am trying to create hyperlinks to email addresses in a sheet. I’ve tried two methods.

First, was putting the email address in one column and then using a formula to add “mailto:” in front of it. This is adding the text but they are not clickable.

I also tried using =HYPERLINK("mailto:" + [Email Column]@row, [Email Column]@row but get an unparseable and am guessing that that formula doesn’t work in Smartsheet. Help please 😊

from what I have read, there is a way to do a mailto in the dashboard, but really need one in the sheets. Having a contact list that isn’t clickable is pretty useless.

KPH

Hi @Saul C.

There is not a HYPERLINK function in Smartsheet which is why you see the unparseable error.

There is a feature enhancement request for mailto on sheets. You can add you vote and comments to that request here:

Hyperlink for mailto: in Reports, Dashboards and Grids

Trang Nguyen

Apr 28, 2023

I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the mailto: link when those dynamic contacts are created or even have the ability to create those hyperlinks with a formula?

---

View Post