排序列不断复位

kkey
kkey ✭✭
编辑12/09/19 内容基本知识

我们使用表单将请求收集到智能表中,默认排序应该首先显示最新的请求。有一个创建(日期)系统列,以便按最新收到的进行排序,但每次关闭工作表时,排序都会继续出现故障,并且默认将最旧的排序为最新的。

这造成了一些格式不一致,因为新请求在进入时采用了以下行的格式。

还有其他人有这个问题吗?有什么建议吗?

评论

=IF(MONTH(Date@row) = MONTH(TODAY()), \"This Month\", \"Last Month\")<\/p>

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":[]}">

使用Smartsheet的趋势