I need to autoassign review of documents from a list of engineers
How can autoassign a document to be reviewed by an enginner in a list of N enginners and avoid to assign a document to the people who is requesting the revision, is that possible?
I have a sheet like this (other columns):
Requester Assigned to
and other sheet with the list of the engineers.
Hope anyone can help me.
Answers
-
Hi @Hugo Trejo
Hope you are fine, i think the best way to do that is by using update request with attachment to be sent using workflow and you can define the conditions to trigger that workflow
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi already have the attachment logic, I used a python progamm to do it and some other API´s , but at this moment I don´t have the logic to assign the person that will review this document, I need to do it from a pool of engineers , I mean something like this link https://community.smartsheet.com/discussion/70221/auto-assign-task-to-next-person-on-contact-list
but it did not work for me yet.
BR
-
Hi @Hugo Trejo
You'd use either VLOOKUP or INDEX/MATCH in a Contact Column referencing the pool of engineers.
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.
-
Hi
So you have any example of the formula I need it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!