过滤下周/下个月的任务
伊恩Pigney
✭
你好,
我是智能表新手。我想设置一个过滤器，这样我就可以只显示那些开始日期少于一周(或一个月)的任务。是否有可能在过滤器条件中使用某种形式的变量或公式，以便它总是返回日期，例如从现在起7天?
谢谢,
伊恩
标签:
评论
-
我建议你下载这个模板，你可以寻找适用于你的要求的表格类型
//www.santa-greenland.com/solutions/smartsheet-formula-examples
-
伊恩Pigney ✭
谢谢你托尼,
我对工作表中单元格中的公式很满意——这是我感兴趣的过滤标准。我希望你能在那里使用公式或特殊变量(比如[下周])，但看起来你不能。
你的回答启发了我想出一个简单的方法来做这件事——我很尴尬我之前没有想到这一点。我创建了一个数字列，用于计算计划的开始日期和今天之间的天数([计划的开始日期]x - today())，然后在该列上过滤<= 7或我想要的任何值。
谢谢,
伊恩
-
完美! !
这次讨论已经结束了。
类别
You da man, @Paul Newcome<\/a>! That works perfectly. Thank you!!!<\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106751,"type":"question","name":"Creating a Group via API","excerpt":"I've searched the API Documentation, as well as github and I'm not seeing anything that allows someone to create a Smartsheet Group via the API - is that possible and I'm just not looking at the right thing? We are trying to set up automation with a multi-tier solution, and have others who are submitting project requests…","categoryID":320,"dateInserted":"2023-06-22T02:44:29+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:30:01+00:00","insertUserID":161991,"insertUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161991,"lastUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3374930070,"url":"https:\/\/community.smartsheet.com\/discussion\/106751\/creating-a-group-via-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106751\/creating-a-group-via-api","format":"Rich","tagIDs":[227,442],"lastPost":{"discussionID":106751,"commentID":381947,"name":"Re: Creating a Group via API","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381947#Comment_381947","dateInserted":"2023-06-23T13:30:01+00:00","insertUserID":161991,"insertUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T13:29:35+00:00","dateAnswered":"2023-06-22T21:15:53+00:00","acceptedAnswers":[{"commentID":381854,"body":"
@isabonita<\/a> <\/p> See below link:<\/p>
