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.
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.
There currently isn't a way to apply a filter to a report but I've added your vote for this to our enhancement request list for further consideration by our Product team.
To further refine your results, you'll want to change the Report Builder criteria, or save a copy of your report and modify the criteria of the copy. You can make a copy of a report by right-clicking on the name of the report (either from the tabs at the top or from within your Home tab) and selecting Save as New.
Please add my vote for this feature! My end users would love to be able to filter the data in their own reports without me needing to go in and make a brand new report for them.
Add my vote! The ability to use filters on reports would be so helpful to stakeholders. In our organization, internal stakeholders service multiple campaigns, so the ability to see all the data or isolate for specific campaigns would be SO much more user friendly. It would also reduce admin time because instead of creating and saving 10 reports (1 for each of our 9 campaign plus a report that shows all campaigns) as well as the time it takes to link them all up on the dashboard.
The move row automation will move all children underneath of a parent row if just the parent row is what triggers the automation.<\/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"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":108818,"type":"question","name":"Convert the text \"yesterday\" to a date format.","excerpt":"I downloaded some issues from Jira and I have a column from there titled \"Last Updated\". In that column it has the regular date format but also text that reads \"Yesterday\" or \"Today\". I figured I could use the TODAY() formula to convert the today dates, but how do I configure that to convert to yesterday? Is it TODAY(-1)?…","snippet":"I downloaded some issues from Jira and I have a column from there titled \"Last Updated\". In that column it has the regular date format but also text that reads \"Yesterday\" or…","categoryID":322,"dateInserted":"2023-08-10T19:51:48+00:00","dateUpdated":"2023-08-11T08:46:44+00:00","dateLastComment":"2023-08-11T12:39:47+00:00","insertUserID":164799,"insertUser":{"userID":164799,"name":"JacksonElla","title":"Senior PM","url":"https:\/\/community.smartsheet.com\/profile\/JacksonElla","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T16:31:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":164799,"lastUser":{"userID":164799,"name":"JacksonElla","title":"Senior PM","url":"https:\/\/community.smartsheet.com\/profile\/JacksonElla","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T16:31:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3383455895,"url":"https:\/\/community.smartsheet.com\/discussion\/108818\/convert-the-text-yesterday-to-a-date-format","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108818\/convert-the-text-yesterday-to-a-date-format","format":"Rich","lastPost":{"discussionID":108818,"commentID":390177,"name":"Re: Convert the text \"yesterday\" to a date format.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390177#Comment_390177","dateInserted":"2023-08-11T12:39:47+00:00","insertUserID":164799,"insertUser":{"userID":164799,"name":"JacksonElla","title":"Senior PM","url":"https:\/\/community.smartsheet.com\/profile\/JacksonElla","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T16:31:43+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-11T12:39:13+00:00","dateAnswered":"2023-08-11T10:36:04+00:00","acceptedAnswers":[{"commentID":390167,"body":"