欢迎来到Smartsheet论坛档案


本论坛中的帖子不再被监控准确性，其内容可能不再是最新的。如果这里有您感兴趣的讨论，并且您想找到(或创建)一个更最新的版本，请访问当前论坛。

报表过滤

史蒂夫·穆斯塔法
史蒂夫·穆斯塔法 ✭✭✭✭✭✭
编辑12/09/19 在2017年帖子

我正在寻找一种方法来过滤报告，同样的方式，你可以在一个表上过滤。似乎在报告中你只能排序，而在表中你可以过滤。如果此功能不可用，我想请求将其添加到未来的增强列表中。

谢谢,

史蒂夫

标签:
· 在Facebook上分享 在推特上分享
«1

评论

这次讨论已经结束。

类别

=SUM(Select the cells you want to sum)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 19:50:46","updateUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T22:24:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":99034,"type":"question","name":"Using COUNTIF and CONTAINS","excerpt":"I need to count the number of times a word is found in a cell. My constraint is that the cell can contain multiple words (from a dropdown) and I'm not sure the formula to use. COUNTIF works just fine if the cell only contains one word. I see a report that used both COUNTIFS and CONTAINS but I can't get it to work. The…","categoryID":322,"dateInserted":"2022-12-22T22:51:19+00:00","dateUpdated":null,"dateLastComment":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":120231,"lastUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3343504327,"url":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","format":"Rich","lastPost":{"discussionID":99034,"commentID":355271,"name":"Re: Using COUNTIF and CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355271#Comment_355271","dateInserted":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+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":"2022-12-23T00:00:06+00:00","dateAnswered":"2022-12-22T23:30:12+00:00","acceptedAnswers":[{"commentID":355270,"body":"

@Pamela Wagner<\/a> <\/p>

Here's an example sheet and formula I made for someone else's topic once.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

=COUNTIFS([Teams Responsible for Testing]:[Teams Responsible for Testing], CONTAINS(\"MIS\", @cell), Status:Status, <>\"Complete\")<\/p>

This is used to find \"MIS\" in the Teams Responsible for Testing column if the Status column is not \"Complete\". It's finding 4 results.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 00:00:06","updateUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":[]},{"discussionID":99015,"type":"question","name":"Nested Criteria on COLLECT","excerpt":"I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([Economy QTY]@row * (INDEX(COLLECT({Price Range}; {Type Range}; \"Economy\"; {Route Range}; CONTAINS(Route@row; @cell); {Active…","categoryID":322,"dateInserted":"2022-12-22T09:37:59+00:00","dateUpdated":"2022-12-22T10:15:13+00:00","dateLastComment":"2022-12-23T04:37:44+00:00","insertUserID":156222,"insertUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":156222,"lastUserID":156222,"lastUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":42,"score":null,"hot":3343475143,"url":"https:\/\/community.smartsheet.com\/discussion\/99015\/nested-criteria-on-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99015\/nested-criteria-on-collect","format":"Rich","tagIDs":[254,472],"lastPost":{"discussionID":99015,"commentID":355280,"name":"Re: Nested Criteria on COLLECT","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355280#Comment_355280","dateInserted":"2022-12-23T04:37:44+00:00","insertUserID":156222,"insertUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+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":"2022-12-23T04:37:50+00:00","dateAnswered":"2022-12-23T04:37:44+00:00","acceptedAnswers":[{"commentID":355280,"body":"

Update :<\/p>

I think I figured it out, the formula has two @cells so I think there might be some inconsistency. I changed how my sheet works by modifying some columns so I don't have to use @cell. Thank you all.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 04:37:50","updateUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">