I'm building a late task report across multiple workspaces/plans. The filter option is not available when viewing report results. Looking to be able to filter by "Status", "Owner", etc.
Hi @Fernando Flores
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Good morning Andree! (or maybe evening?). Thanks for the prompt assistance. So I created a report that gets information from standardized project plans across multiple workgroups. I can always change the report query itself to filter, but I'd like to be able to filter the results within the report sheet.
That is expected behavior. You cannot filter reports, but you can edit the Report Builder to show what you want to filter for.
Ok. In reports you don't have filters as in a sheet. instead you use the report builder to "filter".
I was hoping to skip the report customization and be able to filter within the report sheet. :-/
I'm utilizing the report to track down late tasks and owner assignments across a number of workspace. Editing, or building, a filter for each defeats the purpose as I would then just go through each workspace....
I'd recommend creating multiple reports or export to excel to filter on the information.
Would that work/help?
I also have thought that filtering on a report would be very useful in multiple circumstances. Consider submitting an enhancement request to reports to allow filtering on report data.
Really wish you let the report creator decide whether filters make sense for his report. Youhave a great gris, you should leverage it.
What you are saying is that I need to have a different report for each desire filter. So if the report need to change I now have to change it in many places. Driving up cost of owning and maintaining,
You reports are more like views. The user can edit data. The user should be able to filter data. This is a big miss. I was going to use report to have different users manage different part of scope data for projects that all feeds into master table that my project that drives the detailed project plans.
A true report would be something that is uneditable.
You can create individual reports, but reports in general ARE filtered versions of your data. So instead of creating one report with multiple filters, you create multiple reports from your primary data. Then you share out only the filtered data that makes sense to the user.
I created a report that integrates 3 the complete data of 3 Smartsheets. (Active, Archived, Expired). We have business reasons for wanting 3 separate sheets instead of a status on one sheet.
Select staff need an easy way to find which sheet a client is on. As an Admin, I can change the filter based on customer name or file number but anyone with less than Admin status cannot change this filter. Is there any way around giving them Admin status. That gives them the ability to do too many other things.
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.