动态视图性能问题(时钟)

吉姆十字架
吉姆十字架 ✭✭✭✭✭✭
编辑06/14/22 添加插件和集成

在动态视图中保存时,我一直遇到性能问题。保存非常慢,而且为了触发逻辑,在处理单行时需要多次保存,这一事实使情况变得更糟。我需要确定哪些方面造成了延误。以下是有关基础表单的一些详细信息:

  • 1719行
  • 110列,其中25列是公式
  • 23个有效的交叉表引用
  • 1列用于插入图像
  • 2条件格式
  • 带有公式的活动工作表摘要
  • 9个活动工作流
  • 17视图本身的命名字段逻辑

我试图确定首先要解决哪些问题,以减少处理负载并提高性能,因此更新4行不需要25分钟。

我本人和迫切寻求改进的行政专业人员将非常感谢任何协助。

答案

  • @Jim十字架

    您所报告的问题似乎需要我们的支持团队进行一些调查和排除故障的建议。如果你还没有这样做,我建议通过我们的支持团队打开一个票这种形式

    干杯!

    胡里奥

Hi @Kaleb Riley<\/a><\/p>

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

Have you checked the zoom level?<\/p>

You could also test log out\/in and test another browser.<\/p>

Did that work\/help? <\/p>

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","log":{"dateUpdated":"2022-09-02 11:57:16","updateUser":{"userID":143030,"name":"Kaleb Riley","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb%20Riley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T12:05:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":219,"urlcode":"Sheets","name":"Sheets"}]},{"discussionID":94966,"type":"question","name":"If I deactivate a licensed user, does their license return to the pool of available licenses?","excerpt":"I am the System Admin on an Enterprise plan. If I deactivate a licensed user, does their license return to the pool of available licenses? It still shows them as licensed in User Management, and I can't make any changes to the user without reactivating them.","categoryID":321,"dateInserted":"2022-09-01T15:41:39+00:00","dateUpdated":null,"dateLastComment":"2022-09-01T16:55:21+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":3324099420,"url":"https:\/\/community.smartsheet.com\/discussion\/94966\/if-i-deactivate-a-licensed-user-does-their-license-return-to-the-pool-of-available-licenses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94966\/if-i-deactivate-a-licensed-user-does-their-license-return-to-the-pool-of-available-licenses","format":"Rich","lastPost":{"discussionID":94966,"commentID":342070,"name":"Re: If I deactivate a licensed user, does their license return to the pool of available licenses?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342070#Comment_342070","dateInserted":"2022-09-01T16:55:21+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+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":"2022-09-01T16:53:29+00:00","dateAnswered":"2022-09-01T16:06:31+00:00","acceptedAnswers":[{"commentID":342056,"body":"

Yes, the user you deactivate will no longer have access to the account, but you will not have to transfer ownership of their items and their license will become available again. You have to be careful though, if you reassign that license that user comes back needing one then you will have to make an executive decision on who gets one and who doesn't.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-01 16:53:29","updateUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":94961,"type":"question","name":"How can I use Smartsheet to create Surveys?","excerpt":"I need to get some feedback from a customer group and I want to use Smartsheet to conduct a survey. Has anyone done this?","categoryID":321,"dateInserted":"2022-09-01T14:50:51+00:00","dateUpdated":"2022-09-01T14:52:00+00:00","dateLastComment":"2022-09-01T16:00:37+00:00","insertUserID":151981,"insertUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151981,"lastUserID":151981,"lastUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3324093088,"url":"https:\/\/community.smartsheet.com\/discussion\/94961\/how-can-i-use-smartsheet-to-create-surveys","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94961\/how-can-i-use-smartsheet-to-create-surveys","format":"Rich","lastPost":{"discussionID":94961,"commentID":342055,"name":"Re: How can I use Smartsheet to create Surveys?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342055#Comment_342055","dateInserted":"2022-09-01T16:00:37+00:00","insertUserID":151981,"insertUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+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":"2022-09-01T15:58:15+00:00","dateAnswered":"2022-09-01T15:27:24+00:00","acceptedAnswers":[{"commentID":342048,"body":"

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

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

You could use a form with the questions or the Update Request feature.<\/p>

Would any of those options work\/help? <\/p>

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","log":{"dateUpdated":"2022-09-01 15:58:15","updateUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">