更动态和互动的仪表板

伊姆兰Qurashi
伊姆兰Qurashi ✭✭✭
编辑02/05/21 在内容基本知识

亲爱的所有,

我喜欢Smartsheet仪表板，它具有非常动态的实时信息。然而，如果我们可以使用仪表板中的变量或选项来改变显示的信息，那就更棒了，就像微软的BI一样。

例如，如果我们在报表小部件中显示特定月份的每日销售数据，我们如何更改月份?如果我们在仪表板中有一个交互变量来更改月份，而不是从仪表板中更新不同月份的报告，那就太好了。我知道这是非常复杂的实现，但它将是惊人的。

很想听听你的想法。

谢谢,

伊姆兰

标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

答案

类别

@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":14,"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"}]},{"discussionID":106257,"type":"question","name":"Bulk download of all the PDF attachments in a worksheet","excerpt":"Hello Community, I am quite new to the Smartsheet and came here to get some advice from you all, i would like to know if there is a way to download all the PDFs attached in different rows of worksheet at one go if the attachments are more than 1000, it would be very helpful if you can guide me through the process, i am a…","categoryID":321,"dateInserted":"2023-06-09T11:58:50+00:00","dateUpdated":"2023-06-09T11:59:59+00:00","dateLastComment":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162243,"lastUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3372641303,"url":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","format":"Rich","tagIDs":[268],"lastPost":{"discussionID":106257,"commentID":379882,"name":"Re: Bulk download of all the PDF attachments in a worksheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379882#Comment_379882","dateInserted":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+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-09T16:27:29+00:00","dateAnswered":"2023-06-09T16:01:48+00:00","acceptedAnswers":[{"commentID":379871,"body":"

@Pragati Trivedi<\/a> <\/p>

If you open the attachments using the icon on the right and you have appropriate level of rights to do this, you can download all. I don't know if there is a size or quantity limit.<\/p>

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

Another option is to select multiple files and download groups of files.<\/p>

Hope this helps!<\/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":268,"urlcode":"Attachments","name":"Attachments"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 将智能表组织到文件夹中-对DVs和WorkApps的影响

    你好，我正试图在Smartsheet中组织工作空间列表。如果我创建文件夹并将工作表移动到不同的文件夹中，这会使动态视图和工作应用程序混乱吗?谢谢你,弗兰克

  • 自动向成员发送过期通知

    嗨!我希望有人能帮助我创建一个(功能!)自动化。我需要智能表发送每日通知的任务所有者，如果任务被标记过去到期。目前，我已经能够创建一个自动化，将提醒业主当一个任务变得过期;然而，这是一个一次性通知。我已经……

  • 批量下载工作表中的所有PDF附件

    你好，社区，我对智能表很陌生，来到这里是为了得到你们所有人的一些建议，我想知道如果附件超过1000个，是否有一种方法可以一次性下载不同行工作表中附加的所有pdf，如果你能指导我完成这个过程，那将非常有帮助，我是一个…