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
Comments
-
年代haine Greenwood Employee
Hello Steve,
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.
-
Tamara K ✭
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.
-
年代haine Greenwood Employee
Hi Tamara,
We have a new process for sharing your ideas on potential improvements for Smartsheet. Check out the announcement detailing this process here:https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests#comment-20305
-
Tamara K ✭
Awesome! Thanks, Shaine.
-
My vote too
-
Tibi ✭
-
jfranche ✭
My vote too +1
-
My vote too please.
This will make life easier for managers and owners. Being able to filter from one report will be a good plus.
-
My vote as well
-
Yes please, that would be useful
-
埃里森·琼斯 ✭✭✭✭
I vote for this too!
-
Please add my vote to this as well. It makes no sense to not to be able to have this feature in reports of all things.
Thank you,
米歇尔
-
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.
-
Kelli.Cook ✭✭✭✭
I heard talk about this feature request at Engage last year and am curious about timing for roll-out. Is there any news?
-
Vote this too and we hope to see the implementation soon.
Categories
Thanks! That sorted it!😀<\/span><\/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":[]},{"discussionID":108430,"type":"question","name":"Any idea why apps are missing from apps and integrations?","excerpt":"I can see all the apps my user account has but my admin account just shows an image and tells me to access apps via Solutions Center, but since the recent update all that is listed are templates. Anyone else experiencing this? Perhaps an account level setting? Thanks","snippet":"I can see all the apps my user account has but my admin account just shows an image and tells me to access apps via Solutions Center, but since the recent update all that is…","categoryID":343,"dateInserted":"2023-08-02T16:55:13+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T22:43:15+00:00","insertUserID":157976,"insertUser":{"userID":157976,"name":"scot tupper","url":"https:\/\/community.smartsheet.com\/profile\/scot%20tupper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BEDmARvGKWs!HZlnn1Ozkzs!BAzk9Ud4lRH","dateLastActive":"2023-08-02T22:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157976,"lastUser":{"userID":157976,"name":"scot tupper","url":"https:\/\/community.smartsheet.com\/profile\/scot%20tupper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BEDmARvGKWs!HZlnn1Ozkzs!BAzk9Ud4lRH","dateLastActive":"2023-08-02T22:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3382012708,"url":"https:\/\/community.smartsheet.com\/discussion\/108430\/any-idea-why-apps-are-missing-from-apps-and-integrations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108430\/any-idea-why-apps-are-missing-from-apps-and-integrations","format":"Rich","lastPost":{"discussionID":108430,"commentID":388617,"name":"Re: Any idea why apps are missing from apps and integrations?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388617#Comment_388617","dateInserted":"2023-08-02T22:43:15+00:00","insertUserID":157976,"insertUser":{"userID":157976,"name":"scot tupper","url":"https:\/\/community.smartsheet.com\/profile\/scot%20tupper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BEDmARvGKWs!HZlnn1Ozkzs!BAzk9Ud4lRH","dateLastActive":"2023-08-02T22:39:04+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T09:09:23+00:00","dateAnswered":"2023-08-02T22:43:15+00:00","acceptedAnswers":[{"commentID":388617,"body":" disregard. support reminded me you initiate the connection to the app from the app, then it appears in the list of apps in smartsheet.<\/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":[]},{"discussionID":108410,"type":"question","name":"Using the \"Created Date\" field in formulas","excerpt":"Hello - I am creating a number of fields in various sheets to calculate lead times. One KPI we want to track is the life cycle of a project. I have added the \"Created Date\" field to all sheets and have an additional field that populates an Invoiced Date. I want a new field that will calculate the number of days between the…","snippet":"Hello - I am creating a number of fields in various sheets to calculate lead times. One KPI we want to track is the life cycle of a project. I have added the \"Created Date\" field…","categoryID":322,"dateInserted":"2023-08-02T13:45:01+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T17:51:15+00:00","insertUserID":141394,"insertUser":{"userID":141394,"name":"KGetchell","url":"https:\/\/community.smartsheet.com\/profile\/KGetchell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T18:07:47+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-02T18:59:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":25,"score":null,"hot":3381985576,"url":"https:\/\/community.smartsheet.com\/discussion\/108410\/using-the-created-date-field-in-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108410\/using-the-created-date-field-in-formulas","format":"Rich","lastPost":{"discussionID":108410,"commentID":388557,"name":"Re: Using the \"Created Date\" field in formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388557#Comment_388557","dateInserted":"2023-08-02T17:51:15+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-02T18:59:20+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\/C0IGNY6CEA25\/capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T09:13:22+00:00","dateAnswered":"2023-08-02T15:09:48+00:00","acceptedAnswers":[{"commentID":388501,"body":" The Created (date) field is not the issue in this instance. The problem is the data in your Invoiced Date column is actually text strings instead of date values.<\/p> Try putting this into a date type column and using this new column in place of the Invoiced Date column in your original formula.<\/p> =DATE(VALUE(MID([Invoiced Date (EP)]@row, FIND(\" \", [Invoiced Date (EP]@row) - 4, 4)), VALUE(LEFT([Invoiced Date (EP)]@row, FIND(\"\/\", [Invoiced Date (EP)]@row) - 1)), VALUE(MID([Invoiced Date (EP)]@row, FIND(\"\/\", [Invoiced Date (EP)]@row) + 1, FIND(\"\/\", [Invoiced Date (EP)]@row, FIND(\"\/\", [Invoiced Date (EP)]@row) + 1) - (FIND(\"\/\", [Invoiced Date (EP)]@row) + 1))))<\/p>"},{"commentID":388539,"body":" Double check that you are putting it in a date type column. Can you also provide a screenshot of those same rows with the errors but also showing the Invoiced Date? It is working for me.<\/p>
<\/p>
<\/p>