Automated workflow - duplicating a row within a same sheet and then change some cell values
Here is the purpose of my sheet, it is a task list based on an IT ticketing request system. The new tasks are feed with a form. I also have a dashboard and reports to track tasks per user from this task list.
So here is my idea, in order for my team to monitor their productivity, one specific type of task needs to be done in two steps with two different people. I was thinking to use an automated workflow, that would be triggered when the status of the initial task is completed and then duplicate the task in the bottom of the table and change the owner and status to another state.
I can't find a way to duplicate within the same sheet, how would automate it? Or do you guys see another way to get the same result?
Thanking you in advance for your help!
Help Article Resources
Check out the Formula Handbook template!