Is it possible to generate a subset of a report based on an interactive dashboard entry?
I have an invoice sheet and want to generate a report based on a specific contract # that the user would enter from a dashboard or other mechanism. So the user would enter the contract # and the report output would only show the invoices for that specific contract. The actual report shows all invoices for all contracts. Is this possible and, if so, can you provide a brief explanation along with a reference to a training resource I can use. thank you.
Answers
-
Hi @Brian Benn
I hope you're well and safe!
Yes, it's possible, but it's fairly advanced to set up.
In short.
- A form on a dashboard to select the number
- Submit form
- Refresh Dashboard
Behind the scenes
- Helper sheet that receives the submission
- Helper column(s) (on each sheet) that updates a column to check for that number (latest one) and match it and check a box or similar
- Report on that check box
Make sense?
Would that work/help?
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 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: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.
-
Yes, that is complicated. I'll play with it and see what happens. Are you aware of any training resources that touch on this or similar functionality? I would potentially be doing this with several sheets.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives