Template recommendations for tracking product design approvals and status from design to production?
So I've been looking at Smartsheet as a solution to a project tracking problem, but I'm having a hard time finding a template for the purposes I'm intending it for. If this needs to be created from scratch, I'd love to be pointed in the direction of some resources.
I work at a company where we have many products being designed and created that need approvals and coordination with several departments internally and externally. Think phone accessories with printed and designed material. So no need to redesign the accessory each time, just the artwork and materials.
After watching the Project Management tutorials, it seems like all of them require you to create separate copies of the project management template for each Project. So each project is it's own folder and set of sheets and docs.
This won't be feasible for me, since there are hundreds of the same basic product being designed that we need to be able to track in a single sheet so we can have an 'at-a-glance' view of. I can't just make a hundred separate sheets for each product.
Basically I'm NOT looking for any solutions that require each project to have its own dedicated project sheet.
The workflow that I'm looking for looks something like this:
- Submit basic project/product info via a form
- Form populates a tracking sheet with preliminary info.
- As more info gets made, user can populate the fields(such as SKUs, dates, links, and reference numbers)
- Ability to label at what stage project/product is in from a design/approval standpoint(Designed, Internally approved, submitted to client for approval, etc). This will tell us what action will be needed to move it forward.
- Automate project at risk level based on deadline.
- Ability to have a dashboard to see at risk projects as well as which ones require action to be taken.
I'd prefer to have one line per product, and change it's status via a dropdown menu, but continue to have the date tracking as seen in some of the project management sheets. Rather than setting each milestone deadline in stone, I'd prefer to track when things get approved while referencing the main deadline(in store date, etc)
Answers
-
Have you explored the Proofing feature?
It sounds like that would be a great piece of your solution.
Would that 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives