Automatic Workflows for Sub Tasks

I am working on updating our engineering change request (ECR) process and we are moving the tracking of this process to Smartsheet.

Each ECR needs a variety of things from a few different departments to be complete. Right now the process starts with a form that anyone can submit. New ECRs are reviewed by a Change Board and are then approved. As soon as an ECR is approved and an engineer is assigned to the ECR the row gets copied over to a new sheet (ECO grid). On the ECO grid the primary engineer works collaborates with the head of document control to assign things to the ECR that to be complete. I made two drop down menus allowing multiple selections: Engineering Deliverables and Documentation Deliverables. Each selection is a task that needs to be completed.

Right now I have created workflows to copy rows over to a task list. The first row is copied as soon as a new row is created. For example, when ECR 1256 is approved and moved over to the ECO grid that row is automatically copied over to the ECO Task List. Then I set up workflows that copy the the ECR1256 every time a new deliverable is selected in the engineering deliverables and documentation deliverables. The result is that after all of the deliverables have been selected the Task list will have many copies of the row for ECR 1256. Myself or one of my colleagues then goes in and cleans up the task list so that each row only has one deliverable and then that row is assigned to person to complete the task.

Is there a way to do this where I can copy the rows from one sheet to the other and create automatic sub tasks when a deliverable is selected so that on the task list there is only one deliverable per row? I think there should be workflow to create subtasks that works like the copy row function but where I can assign a parent row and then use the drop down selection columns to designate a subtask.

Thanks,

Katie

Answers

  • Julio S.
    Julio S. Moderator

    Hi @kstaver

    Regarding the process that involves cleaning up your task list, you may add conditions to the copy row workflow to prevent it from running multiple times. In my example below rows will only be copied once the deliverable information has been filled but you can use other operators and conditions to make it as restricted as needed to prevent the Workflow from running multiple times for a single row. 

    On the other hand, it is currently not possible to automatically add subtasks in a sheet based on a dropdown selection or any other criteria, when you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you!

    The alternative way that I can think of would be to substitute the sub-tasks with columns and have different task lists set up for each deliverable type or the most frequent ones. You may then consolidate all tasks from the different deliverable sheets in a Report. If this looks like an option, you may then adjust the automated workflow in the ECO grid to copy rows to each pre-set deliverable task list based on dropdown selections as needed.

    If you'd need further advise on your current sheets/automation configurations, please add some screenshots making sure you have hidden any confidential data.

    I hope this can offer some insights and be of help.

    Cheers!

    Julio