自动仪表板度量更新

苏菲努森
苏菲努森 ✭
在内容基本知识

你好!

我有一个项目的仪表板，我使用一个度量小部件来分享每个目标的更新。我有一个底层表格，每两周向每个目标的负责人发送更新请求。我有一个自动化表内存档旧更新存档表。

我希望更新表(顶部行)的最新更新自动填充到我的仪表板的度量小部件中，但是一旦它们被存档，而不是在仪表板中显示下一行(新的第1行)，小部件显示“丢失数据”错误。

以前有人解决过这个问题吗?

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

最佳答案

答案

类别

Hi @AllenWeston<\/a> <\/p>

I hope you're well and safe!<\/p>

There's a known issue at the moment.<\/p>

\n \n https:\/\/status.smartsheet.com\/incidents\/n3gv8nrd6cyf\n <\/a>\n<\/div>


<\/p>

\n \n https:\/\/status.smartsheet.com\/\n <\/a>\n<\/div>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":106259,"type":"question","name":"Calculate workdays, excluding weekends (Days elapsed)","excerpt":"I found the solution for \"How to calculate days a ticket is open\/closed\" on your site (solution submitted by Andrée Starå), but, I need the formula to count just the weekdays, excluding weekends. I tried a couple of different ways, but cannot get it to work properly. Any help would be greatly appreciated! This is the…","categoryID":321,"dateInserted":"2023-06-09T12:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162244,"lastUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":93,"score":null,"hot":3372908458,"url":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","format":"Rich","lastPost":{"discussionID":106259,"commentID":380147,"name":"Re: Calculate workdays, excluding weekends (Days elapsed)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380147#Comment_380147","dateInserted":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+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\/Y6CX51TQRVBZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T17:37:11+00:00","dateAnswered":"2023-06-12T17:19:34+00:00","acceptedAnswers":[{"commentID":380143,"body":"

Either of these should work. They just approach the logic from a different direction.<\/p>


<\/p>

=IF([Project Completion Date]@row <> \"//www.santa-greenland.com/community/discussion/74547/\", NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row), NETWORKDAYS([Project Start Date]@row, TODAY()))<\/p>


<\/p>

=IF([Project Completion Date]@row = \"//www.santa-greenland.com/community/discussion/74547/\", NETWORKDAYS([Project Start Date]@row, TODAY()), NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row))<\/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":106251,"type":"question","name":"Unable to edit dashboard with Admin rights","excerpt":"Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.","categoryID":321,"dateInserted":"2023-06-09T06:08:55+00:00","dateUpdated":"2023-06-09T07:54:11+00:00","dateLastComment":"2023-06-12T13:55:34+00:00","insertUserID":124399,"insertUser":{"userID":124399,"name":"firestorm","url":"https:\/\/community.smartsheet.com\/profile\/firestorm","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0pnQ_1i5ezw!2uNXv2NG1jQ!_3DRw9ClXTT","dateLastActive":"2023-06-12T07:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T18:23:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":68,"score":null,"hot":3372875069,"url":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106251,"commentID":380080,"name":"Re: Unable to edit dashboard with Admin rights","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380080#Comment_380080","dateInserted":"2023-06-12T13:55:34+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T18:23:21+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-12T08:23:14+00:00","dateAnswered":"2023-06-12T04:13:41+00:00","acceptedAnswers":[{"commentID":380023,"body":"

@firestorm<\/a> <\/p>

Yes, unfortunately, (if I'm not mistaken) a license is needed to be able to edit a Dashboard. <\/p>

The sheet Owner and Admins can add or edit dashboard widgets. A license is required.<\/em><\/p>

More info. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>


<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&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":5370,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势