Consolidated Dashboard or PowerPoint

Tana Rucker
Tana Rucker Overachievers Alumni
edited 06/14/22 inAdd Ons and Integrations

OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy document or dashboard. Is there any way to create the either of the two solutions below without regular manual intervention? APIs and macros considered if you know of anything.

  1. A consolidated dashboard that includes all projects provisioned in Control Center (we cannot publish dashboards).
  2. -or- Generate a series of powerpoint slides with some level of automation from at least 30 active project dashboards. The list of projects can be stored in one Smartsheet folder, but the list of projects will regularly change based on what is being provisioned in SCC.

Any ideas? We ideally do not want to be in the business of opening 30+ project dashboards, screenshotting (is that a word?) each dashboard, sizing/editing it, and pasting that into PowerPoint, and managing that when there are regular changes. Yikes.

Tana Rucker

Charter Communications

https://www.linkedin.com/in/tanarucker/

Tags:
· Share on Facebook Share on Twitter

Comments

Categories

Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/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":106269,"type":"question","name":"Organizing Smartsheets into folders - Impact to DVs and WorkApps","excerpt":"Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank","categoryID":321,"dateInserted":"2023-06-09T14:20:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T15:35:26+00:00","insertUserID":158554,"insertUser":{"userID":158554,"name":"Frank B.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HVYSSRAF5R9\/n9CDGKLAHBDUI.png","dateLastActive":"2023-06-09T15:34:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T21:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":null,"hot":3372645966,"url":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","format":"Rich","tagIDs":[371,443],"lastPost":{"discussionID":106269,"commentID":379859,"name":"Re: Organizing Smartsheets into folders - Impact to DVs and WorkApps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379859#Comment_379859","dateInserted":"2023-06-09T15:35:26+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T21:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:36:14+00:00","dateAnswered":"2023-06-09T15:35:26+00:00","acceptedAnswers":[{"commentID":379859,"body":"

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"

In the Trigger section, select \"When a date is reached\",<\/p>

Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>

Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>

Example below.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/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"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet

  • 动态视图,使用多个列重新联系strict access

    I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I…

  • Organizing Smartsheets into folders - Impact to DVs and WorkApps

    Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank

  • Automation to send past due notifications to members

    Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…