排序列不断复位
我们使用表单将请求收集到智能表中,默认排序应该首先显示最新的请求。有一个创建(日期)系统列,以便按最新收到的进行排序,但每次关闭工作表时,排序都会继续出现故障,并且默认将最旧的排序为最新的。
这造成了一些格式不一致,因为新请求在进入时采用了以下行的格式。
还有其他人有这个问题吗?有什么建议吗?
评论
-
她名叫Stara ✭✭✭✭✭✭
你好,
不幸的是,这是不可能有表自动排序的时刻,但这是一个伟大的想法!
作为一种可能的解决方案,您可以使用报告来代替。
这样行吗?
关于格式一致性,您是将新行放在顶部还是底部?
祝你度过美好的一天!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
黛比·索亚历险记 ✭✭✭✭✭✭
-
kkey ✭✭
谢谢!是的,我们将它设置为将新请求放在表单的顶部,但随后它们与旧请求穿插在一起。
我有一个使用相同功能的不同表单,在我们注销后,似乎没有任何问题。
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
你使用过滤器了吗?
你能更详细地描述一下你的过程吗?也许可以分享一些截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
BillyW ✭
我遇到了与KKey在这篇文章中描述的相同的行为。我看到这个帖子是几年前的了…有解决方案吗?
类别
You were on the right track.<\/p>
Will the current and previous months be the only options? Will there be entries from prior to last month?<\/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":106120,"type":"question","name":"PDF Attachment Downloads","excerpt":"We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?","categoryID":321,"dateInserted":"2023-06-07T10:34:01+00:00","dateUpdated":"2023-06-07T10:38:21+00:00","dateLastComment":"2023-06-07T13:43:04+00:00","insertUserID":162132,"insertUser":{"userID":162132,"name":"Renee1_CRA","url":"https:\/\/community.smartsheet.com\/profile\/Renee1_CRA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T13:46:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-06-07T15:39:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3372281225,"url":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","format":"Rich","lastPost":{"discussionID":106120,"commentID":379260,"name":"Re: PDF Attachment Downloads","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379260#Comment_379260","dateInserted":"2023-06-07T13:43:04+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-06-07T15:39:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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\/H01NI7XP81IL\/screenshot-2023-06-07-at-11-38-08.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 at 11.38.08.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T13:48:56+00:00","dateAnswered":"2023-06-07T13:43:04+00:00","acceptedAnswers":[{"commentID":379260,"body":"
Hi @Renee1_CRA<\/a> <\/p> If you don't want to select the option from the dropdown menu, you can use keyboard shortcuts to open the file in a new tab as well: Ctrl+Click<\/strong> (Windows) or CMD+Click <\/strong>(Mac).<\/p> Cheers,<\/p> Genevieve<\/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":106077,"type":"question","name":"Percentages not displaying correctly in Report Summary","excerpt":"Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…","categoryID":321,"dateInserted":"2023-06-06T16:57:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161188,"lastUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3372222765,"url":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106077,"commentID":379287,"name":"Re: Percentages not displaying correctly in Report Summary","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379287#Comment_379287","dateInserted":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+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\/9KBOWFBASG02\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:54:05+00:00","dateAnswered":"2023-06-07T11:56:42+00:00","acceptedAnswers":[{"commentID":379219,"body":" Hi @RRM<\/a> and @Kleerfyre<\/a> <\/p> The Support team received other reports of this same behaviour yesterday and were able to identify the cause; this should now be resolved! Please refresh your Report and you should see your percentages appear in the Summary rows again.<\/p> Cheers,<\/p> Genevieve<\/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":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">