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.
Hi @BristolCVN<\/a> <\/p>

I hope you're well and safe!<\/p>

You must add\/change the Rule #1 name.<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":108771,"type":"question","name":"Has Smartsheet improved the Workapps notification functionality?","excerpt":"While looking at a Smartsheet Workapp today, I noticed the text highlighted below. It says: \"Automation: You can create automated workflows in Smartsheet to alert people in your app. Learn more\" I was excited to see this because I don't use the Workapp tool since it lacks a way to A) notify users of notifications within…","snippet":"While looking at a Smartsheet Workapp today, I noticed the text highlighted below. It says: \"Automation: You can create automated workflows in Smartsheet to alert people in your…","categoryID":343,"dateInserted":"2023-08-10T01:25:46+00:00","dateUpdated":"2023-08-10T07:34:18+00:00","dateLastComment":"2023-08-10T13:12:38+00:00","insertUserID":13526,"insertUser":{"userID":13526,"name":"Marc Shecter","url":"https:\/\/community.smartsheet.com\/profile\/Marc%20Shecter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/7MDG7HO742ML\/nHOVUT0FAH0M1.jpg","dateLastActive":"2023-08-10T15:38:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-10T16:36:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3383304504,"url":"https:\/\/community.smartsheet.com\/discussion\/108771\/has-smartsheet-improved-the-workapps-notification-functionality","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108771\/has-smartsheet-improved-the-workapps-notification-functionality","format":"Rich","tagIDs":[371,510,514],"lastPost":{"discussionID":108771,"commentID":389996,"name":"Re: Has Smartsheet improved the Workapps notification functionality?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389996#Comment_389996","dateInserted":"2023-08-10T13:12:38+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-10T16:36:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/C4YA4UIUZFSF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T15:39:24+00:00","dateAnswered":"2023-08-10T13:12:38+00:00","acceptedAnswers":[{"commentID":389996,"body":"

Hi @Marc Shecter<\/a> <\/p>

The prompt here is to help Workapp Builders use automations in the underlying Smartsheet sheet to send out notifications. There currently isn't a way to build an automation directly in the Workapp, as you noted. I see you created an Idea Post<\/a> around this, thank you!<\/p>

For your B), you could add the URL to the Workapp in the body text of the notification if that helps.<\/p>

Cheers,<\/p>

Genevieve<\/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":["discussion","question"]},"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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"},{"tagID":514,"urlcode":"slack-notifications","name":"Slack Notifications"}]},{"discussionID":108756,"type":"question","name":"Showing what quarters students are here from date ranges","excerpt":"Hello - I am trying to build a report for my supervisor that shows what quarters students are here from two date ranges. My columns are Experience Start Date Experience End date Quarter - I have this formula in quarter currently that pulls the quarter from whatever month the experience start date begins in =\"Q\" +…","snippet":"Hello - I am trying to build a report for my supervisor that shows what quarters students are here from two date ranges. My columns are Experience Start Date Experience End date…","categoryID":322,"dateInserted":"2023-08-09T19:29:46+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T16:56:30+00:00","insertUserID":164879,"insertUser":{"userID":164879,"name":"Taylorbecker1123","title":"Education Admin Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Taylorbecker1123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-10T16:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164879,"lastUser":{"userID":164879,"name":"Taylorbecker1123","title":"Education Admin Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Taylorbecker1123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-10T16:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3383297176,"url":"https:\/\/community.smartsheet.com\/discussion\/108756\/showing-what-quarters-students-are-here-from-date-ranges","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108756\/showing-what-quarters-students-are-here-from-date-ranges","format":"Rich","lastPost":{"discussionID":108756,"commentID":390066,"name":"Re: Showing what quarters students are here from date ranges","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390066#Comment_390066","dateInserted":"2023-08-10T16:56:30+00:00","insertUserID":164879,"insertUser":{"userID":164879,"name":"Taylorbecker1123","title":"Education Admin Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Taylorbecker1123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-10T16:53:37+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\/MS2Q5K5FZJPC\/smartsheet-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T16:56:13+00:00","dateAnswered":"2023-08-09T21:34:54+00:00","acceptedAnswers":[{"commentID":389920,"body":"

Try this:<\/p>

=\"Q\" + ROUNDUP(MONTH([EXPERIENCE START DATE:]@row) \/ 3) + IF(ROUNDUP(MONTH([EXPERIENCE START DATE:]@row) \/ 3) <> ROUNDUP(MONTH([EXPERIENCE END DATE:]@row) \/ 3), \" - Q\" + ROUNDUP(MONTH([EXPERIENCE END DATE:]@row) \/ 3), \"//www.santa-greenland.com/community/discussion/comment/\")<\/p>

Hope that works for ya!<\/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":[]}">

Trending Posts