Advice Needed to Optimize Workflow
Hello,
I am looking to build a workflow for a review process in Smartsheets. There are multiple stages to this review process. For example, the item is submitted for Group A review. It must be approved by Group in order to be Submitted to Group B. What would be the best and most user friendly way to track who is reviewing the item and the status of the item throughout the group reviews?
Ideally, once Group A approves, the status would trigger a change to Submitted fro Group B. I am trying to avoid having this information in one columns as we have multiple review groups and could make the status very large.
Thanks for the assistance,
Katye
Comments
-
Hi Katye,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Katye
it sounds like you just need to to design into your workflow some "Data Triggers" that replicate a relay race where the baton is passed from one team member to another.
The teams or members can probably best view their work in a Report that only shows them their work and when completed they change their Data Trigger which causes the task to pop up on the next team's task list (Report).
Using Conditional Notifications and approvals will enhance this process which includes those alerts popping up on the mobile App if that is helpful?
There are also some more ways to improve your workflows using the API which follows your rules and achieves greater automation. We call that Smarter Workflow manager.
If that helps you, then good luck, if it would be faster for us to help you do this then as Smartsheet Consultants, that's what our team do, based in the US and UK, just let us know and we will set up a free initial consultation.
Regards
Richardr@smarterbusinesprocesses.com
-
It sounds like you should be able to just use some basic conditions when setting up your "Approval Request".
First Approval Request gets sent to Group A based off of your regular criteria.
The Second Approval Request gets set up to send to Group B when the Group A Approval Status column changes to "Approved".
See screenshots below...
-
Thank all of you so much, this is extremely helpful. I have yet to build this workflow in Smartsheets, but understanding how to build is a huge relief.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!