Extract overdue tasks based on project type

Hi Smartsheet Community :-)
First off, very excited to be using Smartsheet. My team and I really enjoy the awesome functionalities it offers. We are however, struggling a bit with the following.
My team manages two types of projects. Reforms and Launches. We would like to create one report that shows overdue tasks for reforms and another report that shows overdue tasks for launches. What is the cleanest / easiest way of doing this Smartsheet experts? :-D
Some ideas that we though of were:
1) Create a launch folder and a reform folder; have each report extract information from its respective folder
2) Add a new column for all projects that either says "Launch or reform". Create a report that filters based on that new column
3) Somehow leverage the summary report functionality; I find this the most enticing way however, I was not able to filter down to the tasks of the project based on the summary report. It would only let me review the project as a whole and not the tasks within the project.
Answers
-
Hi @Gennadios Cassotis , I would use #2.
-
I hope you're well and safe!
Is everything in one sheet?
Be safe, and have a fantastic weekend!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives