Automations and Reports


I'm pretty sure I already know the answer to this but maybe there is something I hadn't considered before.

Our HR department uses several different SmartSheets for the on/off boarding process. I am only an editor, not an owner, so I cannot create automations from their sheets. I have a report that pulls all the tasks that IT needs to complete from all the different SmartSheets into one report. IT also has it's own SmartSheet of everything everyone is working on in the department. I want to copy rows from my report to this SmartSheet so we do not have to do double entry.

Is there any work around this other than trying to get them to make me an owner so I can set up automations?

Thanks, Lisa