Sign in to submit new ideas and vote
开始

通过电子邮件发送仪表板,手动和自动workflow

TomG
TomG ✭✭✭✭

My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email.

Smartsheet Dashboards are fantastic and we use them heavily with our project teams and leadership. However, I've received the same request on a regular basis from leaders at multiple companies. "Can the dashboard be sent as a weekly status report to me via email?"

While the publishing feature is useful for folks that want to interact with the data, most leaders want information presented in a way they can view and immediately act. Having to open a browser or link, log in (id and password), 2FA approval/input, then select another link or 2 is certainly tedious for everyone, but is a big waste of time for an executive or for someone leading many projects or programs.

As a result, many leaders request their project manager create weekly status reports which largely contains the information from their designed dashboard.

Having a way to do this in an automated way in Smartsheet would save project managers a lot of time each week as manual status reports could be automated, and would improve executive efficiency by putting the information in the location they use very frequently through the day, their inbox.

20
Up
20 votes

On Roadmap·Last Updated

We agree that this is a really important use case. While we can't give to a specific date, we're pleased to say that this is on our roadmap!

Comments

  • Sing C
    Sing C ✭✭✭✭✭

    Everybody loves a weekly report! Our project dashboards are setup (like most I suspect) to surface real-time data, but certain stakeholders and leaders are wedded to the traditional idea of a weekly status report and being able go back and look at last week, last month, etc.

    It would be great to have the 'Send as attachment' option for dashboards the way it exists for reports, and be able to schedule a weekly email with a PDF dashboard attached.

    image.png


    Sing Chen

    PMO Operations Leader,Ceridian

    LinkedIn

  • This would be a great feature to help with weekly project updates.

  • This is a great idea! I would vote to have this added to the SmartSheet base functionality

  • Tom, this is a great idea and would definitely help make the information more availabile.

  • TomG
    TomG ✭✭✭✭

    Thanks for the vote@Jamie Jae! I really hope this gets traction as it would really help execs have a positive perspective on Smartsheet and save PMs loads of time.

  • jasonp
    jasonp ✭✭✭✭
    edited 05/16/23

    What if we were able to schedule a dashboard. So that it would arrive to inboxes. Just like and update request or any other automation. This would save my organization great time. Especially with the use of MS Teams. Then I could schedule dashboards on the template to a Project Update Teams, and they would all post when I schedule them. Keeping inboxes limited to just a reminder to check in.

  • Upvoted! The option to send reports as a scheduled attachment is great, but the limited formatting options available in reports is a drawback. Sending a nicely formatted dashboard in the same way as reports is the straightforward solution.

  • TomG
    TomG ✭✭✭✭

    Absolutely thrilled to see this has been added to the roadmap, thanks for the update!!!

    This topic came up earlier today and I shared that I hoped this would be carried forward and come sometime in the near future. I know there is no timetable yet, but hopefully this is a quick and easy win for both Smartsheet Dev Teams and the user community!

2023-04-30T20:26:26.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":105803,"type":"idea","name":"Desktop App - Column Prop \/ Drop-downs Blurry!","excerpt":"I am seeing many posts (some still not addressed) since this was rolled out for us to use, and although i like the program, this is a major issue for our large company to justify the need to continue using it. This ONLY occurs in the Desktop application for me, though. Firefox, Chrome, Brave, Edge and Opera have no display…","categoryID":349,"dateInserted":"2023-05-30T18:56:49+00:00","dateUpdated":"2023-05-30T18:57:14+00:00","dateLastComment":"2023-05-30T18:56:49+00:00","insertUserID":147586,"insertUser":{"userID":147586,"name":"Julie Becker","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Becker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3mnQf1jqlbw!80_RN_j1-Hw!oNyMYDcvTs5","dateLastActive":"2023-05-30T18:56:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":147586,"lastUserID":147586,"lastUser":{"userID":147586,"name":"Julie Becker","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Becker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3mnQf1jqlbw!80_RN_j1-Hw!oNyMYDcvTs5","dateLastActive":"2023-05-30T18:56:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":7,"score":1,"hot":3370946343,"url":"https:\/\/community.smartsheet.com\/discussion\/105803\/desktop-app-column-prop-drop-downs-blurry","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105803\/desktop-app-column-prop-drop-downs-blurry","format":"Rich","tagIDs":[227,281,283,319,363,491],"lastPost":{"discussionID":105803,"name":"Desktop App - Column Prop \/ Drop-downs Blurry!","url":"https:\/\/community.smartsheet.com\/discussion\/105803\/desktop-app-column-prop-drop-downs-blurry","dateInserted":"2023-05-30T18:56:49+00:00","insertUserID":147586,"insertUser":{"userID":147586,"name":"Julie Becker","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Becker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3mnQf1jqlbw!80_RN_j1-Hw!oNyMYDcvTs5","dateLastActive":"2023-05-30T18:56:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KF9T2AR5X6Y0\/nqaex9peqv.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"nqaEx9PEQV.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":491,"urlcode":"desktop-app","name":"Desktop App"}]},{"discussionID":105782,"type":"idea","name":"Open files in a new window","excerpt":"A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…","categoryID":349,"dateInserted":"2023-05-30T13:01:42+00:00","dateUpdated":null,"dateLastComment":"2023-05-30T13:08:20+00:00","insertUserID":161877,"insertUser":{"userID":161877,"name":"David Perston","url":"https:\/\/community.smartsheet.com\/profile\/David%20Perston","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T13:01:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-30T16:19:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":2,"hot":3370905002,"url":"https:\/\/community.smartsheet.com\/discussion\/105782\/open-files-in-a-new-window","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105782\/open-files-in-a-new-window","format":"Rich","tagIDs":[250,281,283,319,363,446],"lastPost":{"discussionID":105782,"commentID":377897,"name":"Re: Open files in a new window","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377897#Comment_377897","dateInserted":"2023-05-30T13:08:20+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-30T16:19:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":250,"urlcode":"Printing","name":"Printing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":105682,"type":"idea","name":"Setup \"default\" tabs to open within Desktop App","excerpt":"As a power user, I would like to have the ability to have a list of Smartsheet sheets to open as tabs each time I open the desktop app. Favorites are great, but having to manually open up these sheets is honestly a waste of time each day and having a default setup would be far superior.","categoryID":349,"dateInserted":"2023-05-25T11:57:53+00:00","dateUpdated":null,"dateLastComment":"2023-05-30T12:04:55+00:00","insertUserID":147670,"insertUser":{"userID":147670,"name":"BBerry","url":"https:\/\/community.smartsheet.com\/profile\/BBerry","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5cjVuesCdSQ!mmHW_1t7Unw!vVqrqHKY4uI","dateLastActive":"2023-05-25T14:22:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157798,"lastUser":{"userID":157798,"name":"Brian R","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20R","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7BVauwAjR4Q!xGDbMQgxInQ!O3QV6ZgXSDK","dateLastActive":"2023-05-30T12:13:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":31,"score":7,"hot":3370466868,"url":"https:\/\/community.smartsheet.com\/discussion\/105682\/setup-default-tabs-to-open-within-desktop-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105682\/setup-default-tabs-to-open-within-desktop-app","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":105682,"commentID":377891,"name":"Re: Setup \"default\" tabs to open within Desktop App","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377891#Comment_377891","dateInserted":"2023-05-30T12:04:55+00:00","insertUserID":157798,"insertUser":{"userID":157798,"name":"Brian R","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20R","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7BVauwAjR4Q!xGDbMQgxInQ!O3QV6ZgXSDK","dateLastActive":"2023-05-30T12:13:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":7}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">