Copy INTO a sheet?


I know it's possible with the workflow to conditionally copy or move rows to another sheet. I'm wondering if it is possible to copy rows INTO the same sheet, FROM another sheet, based on a condition. I can't see any way to do this with a workflow.

Functionally, what I'm trying to do is add a bunch of sub-tasks to a task based on the type of task. I was going to have the sub-tasks on another sheet, and copy them into the sheet when the new task was identified.

Any thoughts on how this could be achieved, perhaps using some other method?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!