Email address (mailto: link) in Dashboards

Jan Peters
Jan Peters ✭✭✭✭
edited 12/09/19 inSmartsheet Basics

Hi -

Have there been any updates on being able to enter an email address (mailto: link) in Dashboards.

I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts. I've tried but have not been successful.

Any possible workarounds?

Thanks,

Jan P

Tags:
· Share on Facebook Share on Twitter
«1

Comments

  • Marcin P
    Marcin P ✭

    Hi,

    你can try to do it this way:

    1. Create email link like mailto:[email protected]
    2. Shorten it with bitly.com
    3. Paste shortened link into your sheet
    4. Or alternatively paste it under some icon in your dashboard as an interaction -> Go to a URL...

    Please let me know if this work for you.

    Best regards

    Marcin

    · Share on Facebook Share on Twitter
  • Tamara K
    Tamara K ✭

    I'm having this trouble too. I tried bit.ly as@MarcinC suggested, but bit.ly doesn't seem to want to shorten mailto:emailaddresses.

    · Share on Facebook Share on Twitter
  • Marcin P
    Marcin P ✭

    Hi,

    Ok then, try another one. Just tried to shorten my email address and seems work fine:

    https://is.gd/

    · Share on Facebook Share on Twitter
  • Marcin P
    Marcin P ✭

    Hi,

    Ok then, try another one. Just tried to shorten my email address and seems work fine:

    https://is.gd/

    · Share on Facebook Share on Twitter
  • @khush_hello
    @khush_hello ✭✭✭✭

    Hi,

    But are they safe? I mean I have also created a couple using site such ashttps://is.gd/however I have my own doubt(s) on how safe it is when it comes to hacking/cyber security..Just wondering..

    Thanks!

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 04/03/19

    Hi,

    I can't think of any reasons they shouldn't be safe. The only thing I can think of is that the service would collect the email address and use them for spam, possibly.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Terry Little
    Terry Little ✭

    Adding someones email to an external database can make that person susceptible to social engineering attacks not just spam. This particularly true of the owner of the email is unaware their email has been shared. Most URL shortening services have very poor security as well.

    Of course, there are many ways to get someones email address, but making it easier must be weighed against the risk

    · Share on Facebook Share on Twitter
  • Terry Little
    Terry Little ✭

    The lack of support for basic features like embedded email links and a truly crappy file and folder permissions scheme among a huge list of slightly less significant important features is why I am looking for a new platform.

    · Share on Facebook Share on Twitter
  • Ann Spore
    Ann Spore ✭✭

    Agreed. I want to embed email addresses for key contacts on dashboards. Smartsheet?

    · Share on Facebook Share on Twitter
  • Kirsten Kincaid
    Kirsten Kincaid ✭

    I would like to do this as well. Adding email address with mailto: in front does not create a URL considered valid by Smartsheet widget.

    · Share on Facebook Share on Twitter
  • 美妙的Kautz
    美妙的Kautz ✭

    I am surprised this does not seem to be an option with the feedback boxes included in most templates.

    It seems easy enough to create a 'feedback' sheet and corresponding form, which could be set to email responses to the desired email address. However, it is still a lot of work when a simple mailto link might suffice.

    Security and compliance are high priorities for us, so none of these workarounds would be appropriate.

    image.png


    image.png


    · Share on Facebook Share on Twitter
  • Dennis Knipfer
    Dennis Knipfer ✭

    有办法追踪用户增强requests? I'd like to put my vote toward Jennifer G.'s request. This is functionality that should exist without having to go through some potentially unsafe work around.

    · Share on Facebook Share on Twitter
  • bcwilson.ca
    bcwilson.ca ✭✭✭✭✭

    I worked with a competitive software and it was a simple HTML Field that could have calculations in.

    I think Smartsheet could easily implement this.. by creating an HTML column and rendering everything in that column

    The power of doing it that way is you can then put formulas in..

    = New Documents for + [Site Name]@row +""

    Then the old software would generate and email and use the fields to generate it.

    It took updates of our national program documentation from 2 days to about 2 hours with a coffee in my hand

    你could also create links from smartsheet to other items based on formulas.. very poowerful

    · Share on Facebook Share on Twitter

Categories

@Jillian M<\/a> an IF statement will do what you need.<\/p>

=if([Column Name]@row=\"Value\",1,0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107883,"type":"question","name":"Moving closed \"tickets\" to a second sheet","excerpt":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is \"completed\" and over 3 days old to the second sheet. This works well.…","snippet":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the…","categoryID":321,"dateInserted":"2023-07-20T20:03:02+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163730,"lastUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3379770739,"url":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":107883,"commentID":386291,"name":"Re: Moving closed \"tickets\" to a second sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386291#Comment_386291","dateInserted":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T20:50:00+00:00","dateAnswered":"2023-07-20T20:14:12+00:00","acceptedAnswers":[{"commentID":386274,"body":"

@TheoR74<\/a>,<\/p>

As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a \"Text\/Number\" column instead.<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":107872,"type":"question","name":"Using Sum function on 2 referring pages","excerpt":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…","snippet":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum…","categoryID":321,"dateInserted":"2023-07-20T17:37:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163722,"lastUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3379752483,"url":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","format":"Rich","lastPost":{"discussionID":107872,"commentID":386231,"name":"Re: Using Sum function on 2 referring pages","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386231#Comment_386231","dateInserted":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T18:10:07+00:00","dateAnswered":"2023-07-20T17:56:18+00:00","acceptedAnswers":[{"commentID":386226,"body":"

=SUM({AAA Pet Services - Sign Ups Range 1}, {AAA Pet Services - Sign Ups Option 2 Range 1})<\/p>

A comma is needed between each range to sum.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4868,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • True/False formula?

    I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula? I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however,…

  • Moving closed "tickets" to a second sheet

    I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…

  • Using Sum function on 2 referring pages

    I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video