Is it possible to develop a task list from multiple source sheets through automation?
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end.
We have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and create that type of learning object.
Once the project owner has created the course outline and has determined which learning object types they'll need to create for the course, we want to be able to quickly populate a new project sheet, or add to their current one, from source sheets.
I read through this article (Automatically move or copy rows between sheets | Smartsheet Learning Center) but the way I'm reading it implies you can set one source sheet to copy the rows to one destination sheet and that's it. We want to be able to use that source sheet over and over and over, repeatedly.
Right now, the only feasible way of doing it would be to go into each source sheet, one at a time, and perform the copy to another sheet method (Copy Rows to Another Sheet | Smartsheet Learning Center), which can be time consuming if we have a course that needs multiple different learning objects planned for it.
What I am imagining is we select the destination sheet, then we select the learning object order and it will automatically pull copies of the rows from the source sheets to the destination sheet in that order. Is this possible or is it a lofty dream?