Dynamic Report Filters
I don't think this is a feature, but it would be extremely helpful if it was. Let me share the details.
We often use the method of creating a template of something, lets say a sheet, two reports, and a dashboard. We keep these four in a folder, and if we need a new one, we'll copy the folder to the correct location, rename the folder appropriately, then rename the four objects accordingly.
Now the sheet pulls from some other sheets in the same workspace, but all I have to do is input a value in a cell and thanks to all the formulas and sheet references, everything else is filled in as new data is added.
However, after I set that value in the sheet, I have to go into the two reports and update the filters as well. This is where the dynamic filter would be handy.
If I could set a report filter to "column = [Column2] from [SourceSheet]", it would make the copy of the new folder less tedious.
I'm really hoping someone tells me I must be blind because there is this great feature that already exists, but if it does... I can't find it. If it doesn't, I think it would make for a great feature anyways!
See the below screenshots for reference.
Folder that is copied:
Example of the cells within the sheet I want to for the dynamic filter values:
(I change the name (Information2) and the rest populates from another master sheet).
Report filters that needs to be changed on their respective reports on each copy:
Answers
-
Hi @dhall
I hope you're well and safe!
Have you explored the Premium App, Control Center, and Dynamic Reporting feature?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå , I don't believe we are licensed for any of those. I'll confirm with the team internally who manages the licensing. Are you saying one of those will have this feature I'm looking for?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives