Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Filters on Reports

I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added to the future enhancements list.

Thanks,

年代teve

«1

Comments

This discussion has been closed.
Feel free to submit a Product Idea!<\/p>

There's nothing we can do as users. It would require a rebuild of that system. I'm pretty sure it's resource intensive, and runs on a schedule performing the automations.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":108366,"type":"question","name":"Card View Filters","excerpt":"How do I add or change column filters in card view? I had card view set up to arrange columns according to the Resource Coach for each project, but after using it this way for several months, suddenly it changed to the columns being organized by home unit (not helpful). When I tried to change the filter back, the Resource…","snippet":"How do I add or change column filters in card view? I had card view set up to arrange columns according to the Resource Coach for each project, but after using it this way for…","categoryID":321,"dateInserted":"2023-08-01T17:29:06+00:00","dateUpdated":"2023-08-01T17:35:28+00:00","dateLastComment":"2023-08-01T19:17:37+00:00","insertUserID":142896,"insertUser":{"userID":142896,"name":"kathyb","url":"https:\/\/community.smartsheet.com\/profile\/kathyb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T19:20:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":142896,"lastUserID":142896,"lastUser":{"userID":142896,"name":"kathyb","url":"https:\/\/community.smartsheet.com\/profile\/kathyb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T19:20:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3381830203,"url":"https:\/\/community.smartsheet.com\/discussion\/108366\/card-view-filters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108366\/card-view-filters","format":"Rich","lastPost":{"discussionID":108366,"commentID":388288,"name":"Re: Card View Filters","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388288#Comment_388288","dateInserted":"2023-08-01T19:17:37+00:00","insertUserID":142896,"insertUser":{"userID":142896,"name":"kathyb","url":"https:\/\/community.smartsheet.com\/profile\/kathyb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T19:20:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T19:14:38+00:00","dateAnswered":"2023-08-01T18:38:22+00:00","acceptedAnswers":[{"commentID":388278,"body":"

Hello @kathyb<\/a>! The card view \"View by ___\" are the columns that are dropdown lists \/ single select options. If that dropdown list column type changed to \"allow multiple values per cell\" it's no longer a valid column type to organize the card view. Was the Resource Coach switched to a multi-select column type?<\/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":108345,"type":"question","name":"AverageIf with multiple criterion","excerpt":"I would like to find the Average Resolution time (Days) for rows where the date closed is in June 2023. =AVERAGEIF(AND([Date Closed]:[Date Closed], >DATE(2023, 6, 1), [Date Closed]:[Date Closed], DATE(2023, 6, 1), [Date…","categoryID":322,"dateInserted":"2023-08-01T14:29:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T19:48:18+00:00","insertUserID":155497,"insertUser":{"userID":155497,"name":"JSpears","url":"https:\/\/community.smartsheet.com\/profile\/JSpears","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BgDcwSo-92c!7zlc-6IqQLs!HEmr4KUqqxd","dateLastActive":"2023-08-01T20:31:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"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-08-01T20:06:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3381821287,"url":"https:\/\/community.smartsheet.com\/discussion\/108345\/averageif-with-multiple-criterion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108345\/averageif-with-multiple-criterion","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108345,"commentID":388300,"name":"Re: AverageIf with multiple criterion","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388300#Comment_388300","dateInserted":"2023-08-01T19:48:18+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-08-01T20:06:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EFAIAZ6PP2LD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T15:53:35+00:00","dateAnswered":"2023-08-01T14:41:23+00:00","acceptedAnswers":[{"commentID":388203,"body":"

Try this:<\/p>

=AVG(COLLECT([Resolution Time (Days)]:[Resolution Time (Days)], [Date Closed]:[Date Closed], AND(@cell>DATE(2023, 6, 1), @cell<DATE(2023, 6, 30))))<\/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"}]}],"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":[]}">

Trending Posts