帮助按数字和单词排序
目前，我们有一个内置的优先级评分，该评分基于输入在接收表格上的数据
这将填充1-5分或“技术”一词。
当我们通过仪表板上的报告过滤这些信息时，我们希望按降序排序，但希望那些包含“Tech”的信息排在最后而不是前面
我能把单词按降序排列，但不能把它们排在最后——有人能帮忙吗?
答案
-
尼克Korna ✭✭✭✭✭我看不出有什么方法可以直接对单个列进行操作，但是您肯定可以使用Helper列进行操作。在你的助手栏使用以下公式:
=IF([Tech/Score]@row = "Tech"， 0,1)
然后，您可以将Helper列作为第一个排序标准进行排序，将Score列作为第二个排序标准(都是降序的)，以便将分数按所需的顺序排序，“Tech”排在最后。
类别
Latest from Zapier Support.<\/p>
\"I've submitted this feature request on your behalf. That does a few things:<\/em><\/strong><\/p> While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!<\/em><\/strong><\/p> Prioritization is largely dependent on the number of customers affected. Issues with only one interested customer will be auto-closed after 3 years.<\/em><\/strong><\/p> I'm sorry, I wish I had a more immediate solution for you. It never hurts for you to reach out to the app developer directly (Smartsheet in this case) to let them know you're running into an issue with their Zapier integration. We do notify them from our end, but a nudge from their users can sometimes carry more weight!\"<\/em><\/strong><\/p> --<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106323,"type":"question","name":"What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","excerpt":"No one is able to login to the Smartsheet's website.","categoryID":321,"dateInserted":"2023-06-12T15:29:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T16:24:28+00:00","insertUserID":158199,"insertUser":{"userID":158199,"name":"AllenWeston","url":"https:\/\/community.smartsheet.com\/profile\/AllenWeston","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T16:19:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3373172662,"url":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","format":"Rich","lastPost":{"discussionID":106323,"commentID":380131,"name":"Re: What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380131#Comment_380131","dateInserted":"2023-06-12T16:24:28+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T20:32:58+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-12T15:34:20+00:00","dateAnswered":"2023-06-12T15:31:38+00:00","acceptedAnswers":[{"commentID":380118,"body":" Hi @AllenWeston<\/a> <\/p> I hope you're well and safe!<\/p> There's a known issue at the moment.<\/p>
