新的过滤和过滤设置

你好,
我很欣赏新的过滤功能,可以与用户共享过滤器集,好主意。
我有一个改进建议。
我可以要求包含一个过滤条件来将值等同于字段的最大值或最小值吗?
等于最大值
等于最小值
这样,当最大值或最小值或日期在多行中常见时,可以在std过滤器中选择它们。
例如,在一个项目中有几个任务要在同一天完成,使用“与最小值相同”将使我能够创建一个可共享的过滤器来显示等于最小值的所有任务,因此那些要先完成……
例如,在会议记录表中,所有的行动都被标记为上次会议中创建的。可以使用会议日期“与最大值相同”创建筛选器集,以获取上次会议的所有操作。添加一个过滤器,一个<100%完成的过滤器,它是一个未完成的操作列表。
此外,在显示的序列中应用此过滤器(我希望它就是这样做的),将能够灵活地确定要使用的最小/最大值。
例如:Filter 1 <100% Complete删除所有日期早于今天的已完成任务。
过滤器2“截止日期”与“最小”相同,给出所有接下来要完成或关注的任务。
将这些设置为过滤集,它们可以重复使用。
我看到有人在使用这个建议......如果这对你有帮助的话,加上你的赞。
评论
-
Shaine格林伍德 员工
你好,christian——感谢您的输入和示例用例,我会将您的反馈传递给我们的产品团队进行进一步审查。ob欧宝娱乐app手机下载
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
加上我的一票。
克雷格 -
Shaine格林伍德 员工
投票了
类别
You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.<\/p>
<\/p>
If you are ok with the link being in another column, you can use this formula:<\/p>
=\"www.acmetickets.com\/ticket\/\" + [Ticket Number Column Name]@row <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":331,"urlcode":"hyperlink","name":"hyperlink"}]},{"discussionID":106493,"type":"question","name":"Need a formula to take a filename and alter the text","excerpt":"I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores. Filename example: JK_T1_L1_NewFile The filename always follows this rules - 2 letters_2 letters__2 letters _filename I…","categoryID":322,"dateInserted":"2023-06-15T14:06:14+00:00","dateUpdated":"2023-06-15T14:15:38+00:00","dateLastComment":"2023-06-15T15:31:51+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T19:23:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162413,"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-15T17:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3373682885,"url":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","format":"Rich","lastPost":{"discussionID":106493,"commentID":380824,"name":"Re: Need a formula to take a filename and alter the text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380824#Comment_380824","dateInserted":"2023-06-15T15:31:51+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-15T17:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T15:34:11+00:00","dateAnswered":"2023-06-15T14:16:00+00:00","acceptedAnswers":[{"commentID":380785,"body":"
Try this:<\/p>
=LOWER(SUBSTITUTE([Column Name]@row, \"_\", \"\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">